Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12

From: Arnold Mavromatis <A(dot)Mavromatis(at)bom(dot)gov(dot)au>
To: 'Stephan Szabo' <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-bugs(at)postgresql(dot)org
Cc: Lan Tran <L(dot)Tran(at)bom(dot)gov(dot)au>, "'meg(at)bom(dot)gov(dot)au'" <meg(at)bom(dot)gov(dot)au>, "'aam(at)bom(dot)gov(dot)au'" <aam(at)bom(dot)gov(dot)au>
Subject: Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12
Date: 2003-08-21 05:37:06
Message-ID: C5F387003C39D411829E00D0B7496139E2821F@jetstream.ho.bom.gov.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi Stephan and everyone

We have tried PG 7.3.4 (the bug still presents itself)

These are the following results..

Welcome to psql 7.3.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

db2=> select cast(timestamptz '1901/12/13' as date);
date
------------
1901-12-13
(1 row)

db2=> select cast(timestamptz '1901/12/14' as date);
date
------------
1901-12-13
(1 row)

db2=> select cast(timestamptz '1901/12/15' as date);
date
------------
1901-12-15
(1 row)

Compiler switches..

./configure --prefix=/adamdb/postgres/pg_admin/pgsql_7.3.4 --enable-debug
--with-pgport=5433 --without-readline --without-zlib
--enable-integer-datetimes

Everything else was left at default settings

Readline and zlib were bypassed because they are not available.

HP-UX 11.11i

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2003-08-21 06:37:22 Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12
Previous Message Stephan Szabo 2003-08-21 03:00:35 FW: postgresql 7.3.2 bug on date '1901-12-13' and '190 1-1 2 (fwd)

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-08-21 05:40:29 Re: Buglist
Previous Message Vivek Khera 2003-08-21 04:07:31 Re: Buglist