I built the postgres-6.3.2 package on my NetBSD-current/pc532
machine over the last few days. My problem is that it failed
several of the regression tests. int2 and int4 scared me until I
saw that my machine said something like "number too big" and the
expected output was something like "bad format"... However, I got
the following lines out of the test with diff -c:
*** expected/datetime.out Sun Jan 4 19:35:27 1998
- --- results/datetime.out Mon Aug 31 18:38:04 1998
***************
*** 19,31 ****
QUERY: SELECT ('current'::datetime = 'now'::datetime) as "True";
True
----
! t
(1 row)
QUERY: SELECT ('now'::datetime - 'current'::datetime) AS "ZeroSecs";
! ZeroSecs
! --------
! @ 0
(1 row)
QUERY: CREATE TABLE DATETIME_TBL( d1 datetime);
- --- 19,31 ----
QUERY: SELECT ('current'::datetime = 'now'::datetime) as "True";
True
----
! f
(1 row)
QUERY: SELECT ('now'::datetime - 'current'::datetime) AS "ZeroSecs";
! ZeroSecs
! ---------------------------------------
! @ 486 days 22 hours 22 mins 13 secs ago
(1 row)
QUERY: CREATE TABLE DATETIME_TBL( d1 datetime);
That doesn't seem right to me, but I don't know for sure. 8-)
Any hints or suggestions?
Jon Buller