Odd behaviour of timestamptz

[Matteo Beccati <php(at)beccati(dot)com>]

Hi,

I've been recently pointed out an issue with timestamptz on a fedora box
and no one was able to replicate it on other machines. After a quick
chat on the IRC at least another two people could replicate the issue
and all of them were using an RPM package.


PostgreSQL 8.2.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.4.6 20060404 (Red Hat 3.4.6-3)

test=# create TABLE test (data timestamp with time zone);
CREATE TABLE

test=# INSERT into test values ('1910-01-10');
INSERT 0 1

test=# INSERT into test values ('1990-01-10');
INSERT 0 1

test=# SELECT * from test;
           data
----------------------------
1910-01-10 00:00:00+00:19:32
1990-01-10 00:00:00+01
(2 rows)


Similar issues were reported using 8.1.8 on RHEL3:

test=# SELECT * from test2;
           data
---------------------------
 1910-01-10 00:00:00+00:09
 1990-01-10 00:00:00+01
(2 rows)


another 8.2.3 on FC3:

test=# SELECT * from test;
             data
------------------------------
 1910-01-10 00:00:00+00:09:21
 1990-01-10 00:00:00+01
(2 lignes)


and another machine:

test=# SELECT * from test;
           data
---------------------------
 1910-01-10 00:00:00+01:24
 1990-01-10 00:00:00+01
(2 rows)


Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com