Hi,
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
=?ISO-8859-1?Q?Kasper_R=F6nning?= 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;
>
=?ISO-8859-1?Q?Kasper_R=F6nning?= writes:
> I seem to have found a bug in Postgres 9.1.3. Apparently timestamp
> values are stored correctly in the database, but querying it returns
> invalid results. My environment is Windows 7 64bit. The unexpected
> result is that timestamps before 1st of Ma
Hi,
I seem to have found a bug in Postgres 9.1.3. Apparently timestamp
values are stored correctly in the database, but querying it returns
invalid results. My environment is Windows 7 64bit. The unexpected
result is that timestamps before 1st of May 1921 are displayed
incorrectly when time z
