make check fails -- 8 hour time difference in old dates

I just downloaded and installed the latest postgresql
(postgresql-7.2.1) and built it from the sources and ran the
regression tests with the following commands:

./configure --with-CXX --with-perl --with-python --with-tcl --with-openssl --with-pam
make
make test

This failed with errors regarding random, which was ignored, and also
numerous places involving time and date mismatches. The mismatches
always occurred with dates before 1970, so I suspect it has to do with
improper conversion of dates before the epoch. For this reason, I
have also cc-ed this to pgsql-ports(at)postgresql(dot)org as well as the
primary adressee of pgsql-bugs(at)postgresql(dot)org, since it may be O/S
related.

I am installing this copy of postgresql-7.2.1 on a freshly installed
copy of Red Hat Linux 7.3, as this machine was running freebsd with an
older version of postgres previously, with no problems. The switch to
Linux was made possible now that Linux supports large file sizes.
Freebsd was previously used because older linux systems could not
handle the larges files my network intrusion detection application
requires. Every other machine on the network is running Linux except
one nameserver, so the switch to linux was supposed to make my life
easier by means of compatibility.

The hardware is a P3-500 MHz Intel coppermine with 256 MB of ram, and
a 6 GB boot disk, and an 80 GB data disk, both EIDE UDMA.

Here is the regression.diffs file that make test generateed:

---------------- cut here ----------------
*** ./expected/abstime.out Wed Nov 21 12:27:25 2001
--- ./results/abstime.out Tue Jul 30 20:09:30 2002
***************
*** 44,50 ****
| Wed Dec 31 16:00:00 1969 PST
| infinity
| -infinity
! | Sat May 10 23:59:12 1947 PST
| invalid
(7 rows)

--- 44,50 ----
| Wed Dec 31 16:00:00 1969 PST
| infinity
| -infinity
! | Sat May 10 15:59:12 1947 PST
| invalid
(7 rows)

***************
*** 56,62 ****
| Mon May 01 00:30:30 1995 PDT
| Wed Dec 31 16:00:00 1969 PST
| -infinity
! | Sat May 10 23:59:12 1947 PST
(5 rows)

SELECT '' AS six, ABSTIME_TBL.*
--- 56,62 ----
| Mon May 01 00:30:30 1995 PDT
| Wed Dec 31 16:00:00 1969 PST
| -infinity
! | Sat May 10 15:59:12 1947 PST
(5 rows)

SELECT '' AS six, ABSTIME_TBL.*
***************
*** 67,73 ****
| Mon May 01 00:30:30 1995 PDT
| Wed Dec 31 16:00:00 1969 PST
| infinity
! | Sat May 10 23:59:12 1947 PST
| invalid
(6 rows)

--- 67,73 ----
| Mon May 01 00:30:30 1995 PDT
| Wed Dec 31 16:00:00 1969 PST
| infinity
! | Sat May 10 15:59:12 1947 PST
| invalid
(6 rows)

***************
*** 89,95 ****
-------+------------------------------
| Wed Dec 31 16:00:00 1969 PST
| -infinity
! | Sat May 10 23:59:12 1947 PST
(3 rows)

SELECT '' AS four, ABSTIME_TBL.*
--- 89,95 ----
-------+------------------------------
| Wed Dec 31 16:00:00 1969 PST
| -infinity
! | Sat May 10 15:59:12 1947 PST
(3 rows)

SELECT '' AS four, ABSTIME_TBL.*
***************
*** 99,105 ****
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
| -infinity
! | Sat May 10 23:59:12 1947 PST
(4 rows)

SELECT '' AS four, ABSTIME_TBL.*
--- 99,105 ----
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
| -infinity
! | Sat May 10 15:59:12 1947 PST
(4 rows)

SELECT '' AS four, ABSTIME_TBL.*
***************
*** 121,127 ****
ORDER BY abstime;
four | abstime | year | month | day | hour | minute | second
------+------------------------------+------+-------+-----+------+--------+--------
! | Sat May 10 23:59:12 1947 PST | 1947 | 5 | 10 | 23 | 59 | 12
| Wed Dec 31 16:00:00 1969 PST | 1969 | 12 | 31 | 16 | 0 | 0
| Sun Jan 14 03:14:21 1973 PST | 1973 | 1 | 14 | 3 | 14 | 21
| Mon May 01 00:30:30 1995 PDT | 1995 | 5 | 1 | 0 | 30 | 30
--- 121,127 ----
ORDER BY abstime;
four | abstime | year | month | day | hour | minute | second
------+------------------------------+------+-------+-----+------+--------+--------
! | Sat May 10 15:59:12 1947 PST | 1947 | 5 | 10 | 15 | 59 | 12
| Wed Dec 31 16:00:00 1969 PST | 1969 | 12 | 31 | 16 | 0 | 0
| Sun Jan 14 03:14:21 1973 PST | 1973 | 1 | 14 | 3 | 14 | 21
| Mon May 01 00:30:30 1995 PDT | 1995 | 5 | 1 | 0 | 30 | 30

======================================================================

*** ./expected/tinterval.out Fri Sep 28 02:59:53 2001
--- ./results/tinterval.out Tue Jul 30 20:09:30 2002
***************
*** 26,32 ****
five | f1
------+-----------------------------------------------------------------
| ["-infinity" "infinity"]
! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
--- 26,32 ----
five | f1
------+-----------------------------------------------------------------
| ["-infinity" "infinity"]
! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
***************
*** 47,53 ****
WHERE t.f1 #<> '@ 1 months';
three | f1
-------+-----------------------------------------------------------------
! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
(3 rows)
--- 47,53 ----
WHERE t.f1 #<> '@ 1 months';
three | f1
-------+-----------------------------------------------------------------
! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
(3 rows)
***************
*** 75,81 ****
WHERE t.f1 #> '@ 1 year';
three | f1
-------+-----------------------------------------------------------------
! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
(3 rows)
--- 75,81 ----
WHERE t.f1 #> '@ 1 year';
three | f1
-------+-----------------------------------------------------------------
! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
(3 rows)
***************
*** 86,92 ****
WHERE t.f1 #>= '@ 3 years';
three | f1
-------+-----------------------------------------------------------------
! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
(3 rows)
--- 86,92 ----
WHERE t.f1 #>= '@ 3 years';
three | f1
-------+-----------------------------------------------------------------
! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
(3 rows)
***************
*** 115,121 ****
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
(5 rows)

SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2
--- 115,121 ----
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
(5 rows)

SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2
***************
*** 127,133 ****
| ["-infinity" "infinity"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["-infinity" "infinity"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
| ["-infinity" "infinity"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
! | ["-infinity" "infinity"] | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["-infinity" "infinity"]
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["-infinity" "infinity"]
--- 127,133 ----
| ["-infinity" "infinity"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["-infinity" "infinity"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
| ["-infinity" "infinity"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
! | ["-infinity" "infinity"] | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["-infinity" "infinity"]
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["-infinity" "infinity"]
***************
*** 135,143 ****
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["-infinity" "infinity"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
! | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["-infinity" "infinity"]
! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
(14 rows)

-- contains
--- 135,143 ----
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["-infinity" "infinity"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
! | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["-infinity" "infinity"]
! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
(14 rows)

-- contains
***************
*** 150,156 ****
------+-----------------------------------------------------------------
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
! | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
(3 rows)

-- make time interval
--- 150,156 ----
------+-----------------------------------------------------------------
| ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
| ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"]
! | ["Sat May 10 15:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
(3 rows)

-- make time interval

======================================================================

*** ./expected/horology.out Fri Jan 11 22:38:34 2002
--- ./results/horology.out Tue Jul 30 20:09:35 2002
***************
*** 652,658 ****
----+---------------------------------
| -infinity
| infinity
! | Tue Dec 31 16:00:00 1968 PST
| Sat Feb 10 17:32:01 1996 PST
| Sat Feb 10 17:32:01 1996 PST
| Sat Feb 10 17:32:02 1996 PST
--- 652,658 ----
----+---------------------------------
| -infinity
| infinity
! | Tue Dec 31 08:00:00 1968 PST
| Sat Feb 10 17:32:01 1996 PST
| Sat Feb 10 17:32:01 1996 PST
| Sat Feb 10 17:32:02 1996 PST
***************
*** 1721,1746 ****
ORDER BY minus, "timestamp", "interval";
160 | timestamp | interval | minus
-----+------------------------------+-------------------------------+------------------------------
! | Thu Jan 01 00:00:00 1970 PST | @ 34 years | Wed Jan 01 00:00:00 1936 PST
! | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST
! | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST
! | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Thu Mar 01 17:32:01 1962 PST
! | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Sun Dec 30 17:32:01 1962 PST
! | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Mon Dec 31 17:32:01 1962 PST
! | Thu Jan 01 00:00:00 1970 PST | @ 6 years | Wed Jan 01 00:00:00 1964 PST
! | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Fri Dec 31 17:32:01 1965 PST
! | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sat Jan 01 17:32:01 1966 PST
! | Wed Mar 15 02:14:05 2000 PST | @ 34 years | Tue Mar 15 02:14:05 1966 PST
! | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Tue Mar 15 03:14:04 1966 PST
! | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15 08:14:01 1966 PST
! | Wed Mar 15 12:14:03 2000 PST | @ 34 years | Tue Mar 15 12:14:03 1966 PST
! | Wed Mar 15 13:14:02 2000 PST | @ 34 years | Tue Mar 15 13:14:02 1966 PST
! | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 17:32:01 1966 PST
! | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 17:32:01 1967 PST
! | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Fri Sep 22 18:19:20 1967 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Thu Jul 31 12:00:00 1969 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Fri Aug 01 00:00:00 1969 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Wed Oct 01 00:00:00 1969 PDT
| Thu Jan 01 00:00:00 1970 PST | @ 10 days | Mon Dec 22 00:00:00 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Wed Dec 31 19:00:00 1969 PST
--- 1721,1746 ----
ORDER BY minus, "timestamp", "interval";
160 | timestamp | interval | minus
-----+------------------------------+-------------------------------+------------------------------
! | Thu Jan 01 00:00:00 1970 PST | @ 34 years | Tue Dec 31 16:00:00 1935 PST
! | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Wed Feb 28 09:32:01 1962 PST
! | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Wed Feb 28 09:32:01 1962 PST
! | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Thu Mar 01 09:32:01 1962 PST
! | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Sun Dec 30 09:32:01 1962 PST
! | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Mon Dec 31 09:32:01 1962 PST
! | Thu Jan 01 00:00:00 1970 PST | @ 6 years | Tue Dec 31 16:00:00 1963 PST
! | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Fri Dec 31 09:32:01 1965 PST
! | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sat Jan 01 09:32:01 1966 PST
! | Wed Mar 15 02:14:05 2000 PST | @ 34 years | Mon Mar 14 18:14:05 1966 PST
! | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Mon Mar 14 19:14:04 1966 PST
! | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15 00:14:01 1966 PST
! | Wed Mar 15 12:14:03 2000 PST | @ 34 years | Tue Mar 15 04:14:03 1966 PST
! | Wed Mar 15 13:14:02 2000 PST | @ 34 years | Tue Mar 15 05:14:02 1966 PST
! | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 09:32:01 1966 PST
! | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 09:32:01 1967 PST
! | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Fri Sep 22 11:19:20 1967 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Thu Jul 31 05:00:00 1969 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Thu Jul 31 17:00:00 1969 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Tue Sep 30 17:00:00 1969 PDT
| Thu Jan 01 00:00:00 1970 PST | @ 10 days | Mon Dec 22 00:00:00 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Wed Dec 31 19:00:00 1969 PST
***************
*** 2178,2188 ****
ORDER BY abstime, reltime;
ten | abstime | reltime
-----+------------------------------+---------------
! | Sat May 10 23:59:12 1947 PST | @ 14 secs ago
! | Sat May 10 23:59:12 1947 PST | @ 1 min
! | Sat May 10 23:59:12 1947 PST | @ 5 hours
! | Sat May 10 23:59:12 1947 PST | @ 10 days
! | Sat May 10 23:59:12 1947 PST | @ 3 mons
| Wed Dec 31 16:00:00 1969 PST | @ 14 secs ago
| Wed Dec 31 16:00:00 1969 PST | @ 1 min
| Wed Dec 31 16:00:00 1969 PST | @ 5 hours
--- 2178,2188 ----
ORDER BY abstime, reltime;
ten | abstime | reltime
-----+------------------------------+---------------
! | Sat May 10 15:59:12 1947 PST | @ 14 secs ago
! | Sat May 10 15:59:12 1947 PST | @ 1 min
! | Sat May 10 15:59:12 1947 PST | @ 5 hours
! | Sat May 10 15:59:12 1947 PST | @ 10 days
! | Sat May 10 15:59:12 1947 PST | @ 3 mons
| Wed Dec 31 16:00:00 1969 PST | @ 14 secs ago
| Wed Dec 31 16:00:00 1969 PST | @ 1 min
| Wed Dec 31 16:00:00 1969 PST | @ 5 hours
***************
*** 2200,2206 ****
-------+------------------------------
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
! | Sat May 10 23:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
--- 2200,2206 ----
-------+------------------------------
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
! | Sat May 10 15:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
***************
*** 2210,2216 ****
-------+------------------------------
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
! | Sat May 10 23:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
--- 2210,2216 ----
-------+------------------------------
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
! | Sat May 10 15:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
***************
*** 2220,2226 ****
-------+------------------------------
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
! | Sat May 10 23:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
--- 2220,2226 ----
-------+------------------------------
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
! | Sat May 10 15:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
***************
*** 2230,2236 ****
-------+------------------------------
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
! | Sat May 10 23:59:12 1947 PST
(3 rows)

--
--- 2230,2236 ----
-------+------------------------------
| Sun Jan 14 03:14:21 1973 PST
| Wed Dec 31 16:00:00 1969 PST
! | Sat May 10 15:59:12 1947 PST
(3 rows)

--
***************
*** 2289,2295 ****
ORDER BY date, abstime;
four | abstime | date
------+------------------------------+------------
! | Sat May 10 23:59:12 1947 PST | 05-10-1947
| Wed Dec 31 16:00:00 1969 PST | 12-31-1969
| Sun Jan 14 03:14:21 1973 PST | 01-14-1973
| Mon May 01 00:30:30 1995 PDT | 05-01-1995
--- 2289,2295 ----
ORDER BY date, abstime;
four | abstime | date
------+------------------------------+------------
! | Sat May 10 15:59:12 1947 PST | 05-10-1947
| Wed Dec 31 16:00:00 1969 PST | 12-31-1969
| Sun Jan 14 03:14:21 1973 PST | 01-14-1973
| Mon May 01 00:30:30 1995 PDT | 05-01-1995
***************
*** 2418,2424 ****
| Wed Dec 31 16:00:00 1969 PST
| infinity
| -infinity
! | Sat May 10 23:59:12 1947 PST
| invalid
(7 rows)

--- 2418,2424 ----
| Wed Dec 31 16:00:00 1969 PST
| infinity
| -infinity
! | Sat May 10 15:59:12 1947 PST
| invalid
(7 rows)

***************
*** 2500,2506 ****
| 1969-12-31 16:00:00-08
| infinity
| -infinity
! | 1947-05-10 23:59:12-08
| invalid
(7 rows)

--- 2500,2506 ----
| 1969-12-31 16:00:00-08
| infinity
| -infinity
! | 1947-05-10 15:59:12-08
| invalid
(7 rows)

***************
*** 2584,2590 ****
| 12/31/1969 16:00:00 PST
| infinity
| -infinity
! | 05/10/1947 23:59:12 PST
| invalid
(7 rows)

--- 2584,2590 ----
| 12/31/1969 16:00:00 PST
| infinity
| -infinity
! | 05/10/1947 15:59:12 PST
| invalid
(7 rows)

***************
*** 2676,2682 ****
| Wed 31 Dec 16:00:00 1969 PST
| infinity
| -infinity
! | Sat 10 May 23:59:12 1947 PST
| invalid
(7 rows)

--- 2676,2682 ----
| Wed 31 Dec 16:00:00 1969 PST
| infinity
| -infinity
! | Sat 10 May 15:59:12 1947 PST
| invalid
(7 rows)

***************
*** 2761,2767 ****
| 1969-12-31 16:00:00-08
| infinity
| -infinity
! | 1947-05-10 23:59:12-08
| invalid
(7 rows)

--- 2761,2767 ----
| 1969-12-31 16:00:00-08
| infinity
| -infinity
! | 1947-05-10 15:59:12-08
| invalid
(7 rows)

***************
*** 2846,2852 ****
| 31/12/1969 16:00:00 PST
| infinity
| -infinity
! | 10/05/1947 23:59:12 PST
| invalid
(7 rows)

--- 2846,2852 ----
| 31/12/1969 16:00:00 PST
| infinity
| -infinity
! | 10/05/1947 15:59:12 PST
| invalid
(7 rows)

======================================================================

*** ./expected/random.out Thu Jan 6 00:40:54 2000
--- ./results/random.out Tue Jul 30 20:09:50 2002
***************
*** 31,35 ****
WHERE random NOT BETWEEN 80 AND 120;
random
--------
! (0 rows)

--- 31,36 ----
WHERE random NOT BETWEEN 80 AND 120;
random
--------
! 78
! (1 row)

======================================================================

---------------- cut here ----------------

--
-------- "And there came a writing to him from Elijah" [2Ch 21:12] --------
R. J. Brown III rj(at)elilabs(dot)com http://www.elilabs.com/~rj voice 847 543-4060
Elijah Laboratories Inc. 457 Signal Lane, Grayslake IL 60030 fax 847 543-4061
----- M o d e l i n g t h e M e t h o d s o f t h e M i n d ------