Re: Issue when displaying TIMESTAMPTZ values

Kasper Rönning <kasper.ronning@reliabit.fi> writes:
> Thank you for the quick reply! I was completely unaware of the old time
> zones of Helsinki! However I'm afraid that the behaviour of Postgresql
> seems plain wrong to me. An example:

> SET TIME ZONE 'Europe/Helsinki';
> DROP TABLE IF EXISTS test1;
> CREATE TABLE test1 (ts TIMESTAMPTZ);
> INSERT INTO test1 VALUES ('0001-01-01 00:00:00');
> SELECT * FROM test1;
> --               ts
> -- ------------------------------
> --  0001-01-01 00:00:00+01:39:52

> Here I enter a timestamp in Helsinki time zone, and the query result is
> different, even though the time zone is the same.

No, the query result is the same, it's just more fully specified.
        regards, tom lane