Hi,
On Tue, 9 Apr 2002 at 19:43, Thomas Lockhart wrote:
> I don't think that our code checks explicitly for a "-1" return, since
> the range is checked just before the call, but it would probably be a
> good idea if it did
Indeed.
As I noticd yesterday, glibc's mktime() has in the current snapshot
been changed to return -1 for dates before the epoch. Our glibc guru
(Cc'ed) told me, this is according to the standards (C and POSIX)
which say, that time_t is undefined for dates prior the epoch, which
to me seems obvoius, because otherwise the error return couldn't be
distinguished from the time_t value "one second before the epoch").
This change causes some of the regression tests to fail ('abstime',
'tinterval', and 'horology'). All failures occur on dates that are
given in PST, lay between 1900 and 1970, and show a difference of 8
hour (regression.diffs attached).
I've added code to DetermineLocalTimeZone that elogs and ERROR if
mktime returns < 0, which showed, that this also happens in some other
tests, but without affecting the results there (maybe pure luck?).
cu
Reinhard
*** ./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)
======================================================================
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
