Hi again We've actually determined that we didn't compile it but just downloaded a binary from the web...(for HP-UX 11.11) so I've got no idea as to compiler settings used on this binary...
Cheers Arn -----Original Message----- From: Arnold Mavromatis [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 4:11 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; Lan Tran; '[EMAIL PROTECTED]' Subject: FW: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 -13' Hi A test of recommended selects is as follows.. db1=> select * from sfc_days2; stn_num | lsd | max_air_temp ---------+------------+-------------- 86071 | 1901-12-13 | 3.0 (1 row) db1=> select * from sfc_days2 where lsd = to_date('1901-12-13', 'YYYY-MM-DD'); stn_num | lsd | max_air_temp ---------+------------+-------------- 86071 | 1901-12-13 | 3.0 (1 row) db1=> select * from sfc_days2 where lsd = to_date('1901-12-14', 'YYYY-MM-DD'); stn_num | lsd | max_air_temp ---------+------------+-------------- 86071 | 1901-12-13 | 3.0 (1 row) As for compiler options I believe everything was left as default for HP-UX 11.11 (Ie the options that you have recommended I do not know if they were set...) without further investigation... Will try and investigate and let you know... Thanks in advance... Cheers Arn -----Original Message----- From: Stephan Szabo [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 4:08 PM To: Arnold Mavromatis Cc: [EMAIL PROTECTED]; Lan Tran Subject: Re: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13' 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...)? ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
