Re: Odd behaviour of timestamptz

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

Hi,

Michael Glaesemann wrote:
>> test=# SELECT * from test;
>>            data
>> ----------------------------
>> 1910-01-10 00:00:00+00:19:32
>> 1990-01-10 00:00:00+01
>> (2 rows)
> 
> I suspect your RPMs build PostgreSQL without --enable-integer-datetimes.
> Without this configure flag, timestamps are represented as floats, with
> all of the imprecision that implies. See the second note below the
> Date/Time Types table:
> 
> http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATATYPE-DATETIME-TABLE

In fact I was thinking to the opposite, but at least one of them didn't
use --enable-integer-datetimes. I could understand problems representing
microseconds, but not the time zone...


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