Some timestamp problems - Mailing list pgsql-admin

From Vilson farias
Subject Some timestamp problems
Date
Msg-id 0ad501c24f96$900a5480$98a0a8c0@dgtac
Whole thread Raw
List pgsql-admin
Greetings,

  I found some strange behaviour in 7.1.2. Is it the same thing on 7.2.2 ?

  I don't know if it's a psql bug, but I would like to report it anyway

bxs=# \d test2
                     Table "test2"
    Attribute     |           Type           | Modifier
------------------+--------------------------+----------
 x                | integer                  |
 apagar_menor_que | timestamp with time zone |

bxs=# insert into test2 values(1, '2111-10-01 04:23:59.999');
INSERT 259672 1
bxs=# insert into test2 values(2, '20001-10-01 04:23:50');
INSERT 259673 1
bxs=# insert into test2 values(3, '20001-10-01 04:23:59');
INSERT 259674 1
bxs=# insert into test2 values(4, '20001-10-01 04:23:59.99');
INSERT 259675 1
bxs=# insert into test2 values(5, '20001-10-01 04:23:59.999');
INSERT 259676 1
bxs=# insert into test2 values(6, '20001-10-01 04:23:59.998');
INSERT 259677 1
bxs=# SELECT * FROM test2;
 x |    apagar_menor_que
---+------------------------
 1 | 2111-10-01 04:23:60.00
 2 | 20001-10-01 04:2350
 3 | 20001-10-01 04:2359
 4 | 20001-10-01 04:2359.99
 5 | 20001-10-01 04:2360.00
 6 | 20001-10-01 04:2360.00
(6 rows)

bxs=#


Best regards from Brazil,

----------------------------------------------------------------------------
----
José Vilson de Mello de Farias
Software Engineer

Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179




pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Silencing NOTICEs in Perl Pg
Next
From: Bruce Momjian
Date:
Subject: Re: Interpretting WAL debug.