regression.diffs
text/plain
Filename: regression.diffs
Type: text/plain
Part: 0
*** ./expected/abstime.out Wed Nov 21 18:27:25 2001
--- ./results/abstime.out Thu Apr 11 12:38:51 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 07:59:53 2001
--- ./results/tinterval.out Thu Apr 11 12:38:51 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 Sat Jan 12 04:38:34 2002
--- ./results/horology.out Thu Apr 11 12:38:53 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)
======================================================================