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