I'm taking a MS level database design class this semester, and didn't
really want to use the school's ORACLE database on their machines, so...
I built the postgres-6.3.2 package on my NetBSD-current/pc532 machine
over the last few days. For those of you who care slightly, this is
a NS32532 based machine from the early '90s and I had to add a couple
of lines af assembler to get the thing to build 8-) I'll send a set
of diffs in when I think it works.
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 8-) Any suggestions?
Jon Buller
