Re: Odd behaviour of timestamptz

[Michael Glaesemann <grzm(at)seespotcode(dot)net>]

On Feb 21, 2007, at 17:15 , Matteo Beccati wrote:

> 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)

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

Michael Glaesemann
grzm seespotcode net