Re: Some timestamp problems

I think there is plenty of time to address the Y10K problem... :)

JLL

Vilson farias wrote:
>
> 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(dot)farias(at)digitro(dot)com(dot)br
> Tel.: +55 48 281 7158
> ICQ 11866179
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly