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