| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Arnold Mavromatis <A(dot)Mavromatis(at)bom(dot)gov(dot)au> |
| Cc: | <pgsql-bugs(at)postgresql(dot)org>, Lan Tran <L(dot)Tran(at)bom(dot)gov(dot)au> |
| Subject: | Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13' |
| Date: | 2003-08-20 06:08:24 |
| Message-ID: | 20030819230405.H91017-100000@megazone.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, 20 Aug 2003, Arnold Mavromatis wrote:
> PostgreSQL info
> Server version PostgreSQL 7.3.2 on hppa2.0w-hp-hpux11.11
> Engine Version 7.3.2
> Compiled by GCC 3.2.1
I couldn't duplicate on Redhat9 using 7.3.4 or 7.4 beta.
What does a plain select to_date('1901-12-13', 'YYYY-MM-DD')
and select to_date('1901-12-14', 'YYYY-MM-DD') give you?
And did you give --enable-integer-datetimes to configure, and
what compilation options were used on the files (specifically was
-O2 used or a higher level, was -ffast-math used, etc...)?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnold Mavromatis | 2003-08-20 06:11:04 | FW: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 -13' |
| Previous Message | Arnold Mavromatis | 2003-08-20 05:13:38 | postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13' - PK v iolation |