*** expected/float8.out Sun Mar 19 23:19:10 2000 --- results/float8.out Sat Dec 30 00:29:10 2000 *************** *** 214,220 **** SET f1 = FLOAT8_TBL.f1 * '-1' WHERE FLOAT8_TBL.f1 > '0.0'; SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; ! ERROR: Bad float8 input format -- overflow SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ERROR: pow() result is out of range SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ; --- 214,220 ---- SET f1 = FLOAT8_TBL.f1 * '-1' WHERE FLOAT8_TBL.f1 > '0.0'; SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ERROR: pow() result is out of range SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ; ---------------------- *** expected/timestamp.out Fri Apr 7 14:17:42 2000 --- results/timestamp.out Sat Dec 30 00:30:24 2000 *************** *** 190,265 **** INSERT INTO TIMESTAMP_TBL VALUES ('Feb 16 17:32:01 5097 BC'); ERROR: Timestamp out of range 'Feb 16 17:32:01 5097 BC' SELECT '' AS "66", d1 FROM TIMESTAMP_TBL; ! 66 | d1 ! ----+--------------------------------- ! | invalid ! | -infinity ! | infinity ! | epoch ! | Mon Feb 10 17:32:01 1997 PST ! | invalid ! | invalid ! | Mon Feb 10 17:32:01.00 1997 PST ! | Mon Feb 10 17:32:02.00 1997 PST ! | Mon Feb 10 17:32:01.40 1997 PST ! | Mon Feb 10 17:32:01.50 1997 PST ! | Mon Feb 10 17:32:01.60 1997 PST ! | Thu Jan 02 00:00:00 1997 PST ! | Thu Jan 02 03:04:05 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Tue Jun 10 17:32:01 1997 PDT ! | Wed Mar 15 08:14:01 2000 PST ! | Wed Mar 15 04:14:02 2000 PST ! | Wed Mar 15 02:14:03 2000 PST ! | Wed Mar 15 03:14:04 2000 PST ! | Wed Mar 15 01:14:05 2000 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:00 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 09:32:01 1997 PST ! | Mon Feb 10 09:32:01 1997 PST ! | Mon Feb 10 09:32:01 1997 PST ! | Tue Jun 10 18:32:01 1997 PDT ! | Mon Feb 10 17:32:01 1997 PST ! | Tue Feb 11 17:32:01 1997 PST ! | Wed Feb 12 17:32:01 1997 PST ! | Thu Feb 13 17:32:01 1997 PST ! | Fri Feb 14 17:32:01 1997 PST ! | Sat Feb 15 17:32:01 1997 PST ! | Sun Feb 16 17:32:01 1997 PST ! | Tue Feb 16 17:32 0097 BC ! | Sat Feb 16 17:32:01 0097 ! | Thu Feb 16 17:32:01 0597 ! | Tue Feb 16 17:32:01 1097 ! | Sat Feb 16 17:32:01 1697 ! | Thu Feb 16 17:32:01 1797 ! | Tue Feb 16 17:32:01 1897 ! | Sun Feb 16 17:32:01 1997 PST ! | Sat Feb 16 17:32:01 2097 ! | Wed Feb 28 17:32:01 1996 PST ! | Thu Feb 29 17:32:01 1996 PST ! | Fri Mar 01 17:32:01 1996 PST ! | Mon Dec 30 17:32:01 1996 PST ! | Tue Dec 31 17:32:01 1996 PST ! | Wed Jan 01 17:32:01 1997 PST ! | Fri Feb 28 17:32:01 1997 PST ! | Sat Mar 01 17:32:01 1997 PST ! | Tue Dec 30 17:32:01 1997 PST ! | Wed Dec 31 17:32:01 1997 PST ! | Fri Dec 31 17:32:01 1999 PST ! | Sat Jan 01 17:32:01 2000 PST ! | Sun Dec 31 17:32:01 2000 PST ! | Mon Jan 01 17:32:01 2001 PST ! (66 rows) ! -- Demonstrate functions and operators SELECT '' AS "47", d1 FROM TIMESTAMP_TBL WHERE d1 > timestamp '1997-01-02' and d1 != timestamp 'current'; --- 190,196 ---- INSERT INTO TIMESTAMP_TBL VALUES ('Feb 16 17:32:01 5097 BC'); ERROR: Timestamp out of range 'Feb 16 17:32:01 5097 BC' SELECT '' AS "66", d1 FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero -- Demonstrate functions and operators SELECT '' AS "47", d1 FROM TIMESTAMP_TBL WHERE d1 > timestamp '1997-01-02' and d1 != timestamp 'current'; *************** *** 487,633 **** (48 rows) SELECT '' AS "66", d1 + interval '1 year' AS one_year FROM TIMESTAMP_TBL; ! 66 | one_year ! ----+--------------------------------- ! | invalid ! | -infinity ! | infinity ! | Thu Dec 31 16:00:00 1970 PST ! | Tue Feb 10 17:32:01 1998 PST ! | invalid ! | invalid ! | Tue Feb 10 17:32:01.00 1998 PST ! | Tue Feb 10 17:32:02.00 1998 PST ! | Tue Feb 10 17:32:01.40 1998 PST ! | Tue Feb 10 17:32:01.50 1998 PST ! | Tue Feb 10 17:32:01.60 1998 PST ! | Fri Jan 02 00:00:00 1998 PST ! | Fri Jan 02 03:04:05 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Wed Jun 10 17:32:01 1998 PDT ! | Thu Mar 15 08:14:01 2001 PST ! | Thu Mar 15 04:14:02 2001 PST ! | Thu Mar 15 02:14:03 2001 PST ! | Thu Mar 15 03:14:04 2001 PST ! | Thu Mar 15 01:14:05 2001 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:00 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 17:32:01 1998 PST ! | Tue Feb 10 09:32:01 1998 PST ! | Tue Feb 10 09:32:01 1998 PST ! | Tue Feb 10 09:32:01 1998 PST ! | Wed Jun 10 18:32:01 1998 PDT ! | Tue Feb 10 17:32:01 1998 PST ! | Wed Feb 11 17:32:01 1998 PST ! | Thu Feb 12 17:32:01 1998 PST ! | Fri Feb 13 17:32:01 1998 PST ! | Sat Feb 14 17:32:01 1998 PST ! | Sun Feb 15 17:32:01 1998 PST ! | Mon Feb 16 17:32:01 1998 PST ! | Thu Feb 16 17:32 0096 BC ! | Sun Feb 16 17:32:01 0098 ! | Fri Feb 16 17:32:01 0598 ! | Wed Feb 16 17:32:01 1098 ! | Sun Feb 16 17:32:01 1698 ! | Fri Feb 16 17:32:01 1798 ! | Wed Feb 16 17:32:01 1898 ! | Mon Feb 16 17:32:01 1998 PST ! | Sun Feb 16 17:32:01 2098 ! | Fri Feb 28 17:32:01 1997 PST ! | Fri Feb 28 17:32:01 1997 PST ! | Sat Mar 01 17:32:01 1997 PST ! | Tue Dec 30 17:32:01 1997 PST ! | Wed Dec 31 17:32:01 1997 PST ! | Thu Jan 01 17:32:01 1998 PST ! | Sat Feb 28 17:32:01 1998 PST ! | Sun Mar 01 17:32:01 1998 PST ! | Wed Dec 30 17:32:01 1998 PST ! | Thu Dec 31 17:32:01 1998 PST ! | Sun Dec 31 17:32:01 2000 PST ! | Mon Jan 01 17:32:01 2001 PST ! | Mon Dec 31 17:32:01 2001 PST ! | Tue Jan 01 17:32:01 2002 PST ! (66 rows) ! SELECT '' AS "66", d1 - interval '1 year' AS one_year FROM TIMESTAMP_TBL; ! 66 | one_year ! ----+--------------------------------- ! | invalid ! | -infinity ! | infinity ! | Tue Dec 31 16:00:00 1968 PST ! | Sat Feb 10 17:32:01 1996 PST ! | invalid ! | invalid ! | Sat Feb 10 17:32:01.00 1996 PST ! | Sat Feb 10 17:32:02.00 1996 PST ! | Sat Feb 10 17:32:01.40 1996 PST ! | Sat Feb 10 17:32:01.50 1996 PST ! | Sat Feb 10 17:32:01.60 1996 PST ! | Tue Jan 02 00:00:00 1996 PST ! | Tue Jan 02 03:04:05 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Mon Jun 10 17:32:01 1996 PDT ! | Mon Mar 15 08:14:01 1999 PST ! | Mon Mar 15 04:14:02 1999 PST ! | Mon Mar 15 02:14:03 1999 PST ! | Mon Mar 15 03:14:04 1999 PST ! | Mon Mar 15 01:14:05 1999 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:00 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 17:32:01 1996 PST ! | Sat Feb 10 09:32:01 1996 PST ! | Sat Feb 10 09:32:01 1996 PST ! | Sat Feb 10 09:32:01 1996 PST ! | Mon Jun 10 18:32:01 1996 PDT ! | Sat Feb 10 17:32:01 1996 PST ! | Sun Feb 11 17:32:01 1996 PST ! | Mon Feb 12 17:32:01 1996 PST ! | Tue Feb 13 17:32:01 1996 PST ! | Wed Feb 14 17:32:01 1996 PST ! | Thu Feb 15 17:32:01 1996 PST ! | Fri Feb 16 17:32:01 1996 PST ! | Mon Feb 16 17:32 0098 BC ! | Thu Feb 16 17:32:01 0096 ! | Tue Feb 16 17:32:01 0596 ! | Sun Feb 16 17:32:01 1096 ! | Thu Feb 16 17:32:01 1696 ! | Tue Feb 16 17:32:01 1796 ! | Sun Feb 16 17:32:01 1896 ! | Fri Feb 16 17:32:01 1996 PST ! | Thu Feb 16 17:32:01 2096 ! | Tue Feb 28 17:32:01 1995 PST ! | Tue Feb 28 17:32:01 1995 PST ! | Wed Mar 01 17:32:01 1995 PST ! | Sat Dec 30 17:32:01 1995 PST ! | Sun Dec 31 17:32:01 1995 PST ! | Mon Jan 01 17:32:01 1996 PST ! | Wed Feb 28 17:32:01 1996 PST ! | Fri Mar 01 17:32:01 1996 PST ! | Mon Dec 30 17:32:01 1996 PST ! | Tue Dec 31 17:32:01 1996 PST ! | Thu Dec 31 17:32:01 1998 PST ! | Fri Jan 01 17:32:01 1999 PST ! | Fri Dec 31 17:32:01 1999 PST ! | Sat Jan 01 17:32:01 2000 PST ! (66 rows) ! SELECT '' AS "53", d1 - timestamp '1997-01-02' AS diff FROM TIMESTAMP_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; 53 | diff --- 418,426 ---- (48 rows) SELECT '' AS "66", d1 + interval '1 year' AS one_year FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS "66", d1 - interval '1 year' AS one_year FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS "53", d1 - timestamp '1997-01-02' AS diff FROM TIMESTAMP_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01'; 53 | diff ---------------------- *** expected/horology.out Mon Mar 20 23:59:14 2000 --- results/horology.out Sat Dec 30 00:30:40 2000 *************** *** 771,794 **** SELECT '' AS five, d1 AS timestamp, abstime(d1) AS abstime FROM TIMESTAMP_TBL WHERE NOT isfinite(d1); ! five | timestamp | abstime ! ------+-----------+----------- ! | invalid | invalid ! | -infinity | -infinity ! | infinity | infinity ! | invalid | invalid ! | invalid | invalid ! (5 rows) ! SELECT '' AS three, f1 as abstime, timestamp(f1) AS timestamp FROM ABSTIME_TBL WHERE NOT isfinite(f1); ! three | abstime | timestamp ! -------+-----------+----------- ! | infinity | infinity ! | -infinity | -infinity ! | invalid | invalid ! (3 rows) ! SELECT '' AS ten, f1 AS interval, reltime( f1) AS reltime FROM INTERVAL_TBL; ten | interval | reltime --- 771,780 ---- SELECT '' AS five, d1 AS timestamp, abstime(d1) AS abstime FROM TIMESTAMP_TBL WHERE NOT isfinite(d1); ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS three, f1 as abstime, timestamp(f1) AS timestamp FROM ABSTIME_TBL WHERE NOT isfinite(f1); ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS ten, f1 AS interval, reltime( f1) AS reltime FROM INTERVAL_TBL; ten | interval | reltime *************** *** 825,900 **** SHOW DateStyle; NOTICE: DateStyle is Postgres with US (NonEuropean) conventions SELECT '' AS "66", d1 AS us_postgres FROM TIMESTAMP_TBL; ! 66 | us_postgres ! ----+--------------------------------- ! | invalid ! | -infinity ! | infinity ! | epoch ! | Mon Feb 10 17:32:01 1997 PST ! | invalid ! | invalid ! | Mon Feb 10 17:32:01.00 1997 PST ! | Mon Feb 10 17:32:02.00 1997 PST ! | Mon Feb 10 17:32:01.40 1997 PST ! | Mon Feb 10 17:32:01.50 1997 PST ! | Mon Feb 10 17:32:01.60 1997 PST ! | Thu Jan 02 00:00:00 1997 PST ! | Thu Jan 02 03:04:05 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Tue Jun 10 17:32:01 1997 PDT ! | Wed Mar 15 08:14:01 2000 PST ! | Wed Mar 15 04:14:02 2000 PST ! | Wed Mar 15 02:14:03 2000 PST ! | Wed Mar 15 03:14:04 2000 PST ! | Wed Mar 15 01:14:05 2000 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:00 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 17:32:01 1997 PST ! | Mon Feb 10 09:32:01 1997 PST ! | Mon Feb 10 09:32:01 1997 PST ! | Mon Feb 10 09:32:01 1997 PST ! | Tue Jun 10 18:32:01 1997 PDT ! | Mon Feb 10 17:32:01 1997 PST ! | Tue Feb 11 17:32:01 1997 PST ! | Wed Feb 12 17:32:01 1997 PST ! | Thu Feb 13 17:32:01 1997 PST ! | Fri Feb 14 17:32:01 1997 PST ! | Sat Feb 15 17:32:01 1997 PST ! | Sun Feb 16 17:32:01 1997 PST ! | Tue Feb 16 17:32 0097 BC ! | Sat Feb 16 17:32:01 0097 ! | Thu Feb 16 17:32:01 0597 ! | Tue Feb 16 17:32:01 1097 ! | Sat Feb 16 17:32:01 1697 ! | Thu Feb 16 17:32:01 1797 ! | Tue Feb 16 17:32:01 1897 ! | Sun Feb 16 17:32:01 1997 PST ! | Sat Feb 16 17:32:01 2097 ! | Wed Feb 28 17:32:01 1996 PST ! | Thu Feb 29 17:32:01 1996 PST ! | Fri Mar 01 17:32:01 1996 PST ! | Mon Dec 30 17:32:01 1996 PST ! | Tue Dec 31 17:32:01 1996 PST ! | Wed Jan 01 17:32:01 1997 PST ! | Fri Feb 28 17:32:01 1997 PST ! | Sat Mar 01 17:32:01 1997 PST ! | Tue Dec 30 17:32:01 1997 PST ! | Wed Dec 31 17:32:01 1997 PST ! | Fri Dec 31 17:32:01 1999 PST ! | Sat Jan 01 17:32:01 2000 PST ! | Sun Dec 31 17:32:01 2000 PST ! | Mon Jan 01 17:32:01 2001 PST ! (66 rows) ! SELECT '' AS eight, f1 AS us_postgres FROM ABSTIME_TBL; eight | us_postgres -------+------------------------------ --- 811,817 ---- SHOW DateStyle; NOTICE: DateStyle is Postgres with US (NonEuropean) conventions SELECT '' AS "66", d1 AS us_postgres FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS eight, f1 AS us_postgres FROM ABSTIME_TBL; eight | us_postgres -------+------------------------------ *************** *** 910,985 **** SET DateStyle TO 'US,ISO'; SELECT '' AS "66", d1 AS us_iso FROM TIMESTAMP_TBL; ! 66 | us_iso ! ----+--------------------------- ! | invalid ! | -infinity ! | infinity ! | epoch ! | 1997-02-10 17:32:01-08 ! | invalid ! | invalid ! | 1997-02-10 17:32:01.00-08 ! | 1997-02-10 17:32:02.00-08 ! | 1997-02-10 17:32:01.40-08 ! | 1997-02-10 17:32:01.50-08 ! | 1997-02-10 17:32:01.60-08 ! | 1997-01-02 00:00:00-08 ! | 1997-01-02 03:04:05-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-06-10 17:32:01-07 ! | 2000-03-15 08:14:01-08 ! | 2000-03-15 04:14:02-08 ! | 2000-03-15 02:14:03-08 ! | 2000-03-15 03:14:04-08 ! | 2000-03-15 01:14:05-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:00-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 09:32:01-08 ! | 1997-02-10 09:32:01-08 ! | 1997-02-10 09:32:01-08 ! | 1997-06-10 18:32:01-07 ! | 1997-02-10 17:32:01-08 ! | 1997-02-11 17:32:01-08 ! | 1997-02-12 17:32:01-08 ! | 1997-02-13 17:32:01-08 ! | 1997-02-14 17:32:01-08 ! | 1997-02-15 17:32:01-08 ! | 1997-02-16 17:32:01-08 ! | 0097-02-16 17:32 BC ! | 0097-02-16 17:32:01 ! | 0597-02-16 17:32:01 ! | 1097-02-16 17:32:01 ! | 1697-02-16 17:32:01 ! | 1797-02-16 17:32:01 ! | 1897-02-16 17:32:01 ! | 1997-02-16 17:32:01-08 ! | 2097-02-16 17:32:01 ! | 1996-02-28 17:32:01-08 ! | 1996-02-29 17:32:01-08 ! | 1996-03-01 17:32:01-08 ! | 1996-12-30 17:32:01-08 ! | 1996-12-31 17:32:01-08 ! | 1997-01-01 17:32:01-08 ! | 1997-02-28 17:32:01-08 ! | 1997-03-01 17:32:01-08 ! | 1997-12-30 17:32:01-08 ! | 1997-12-31 17:32:01-08 ! | 1999-12-31 17:32:01-08 ! | 2000-01-01 17:32:01-08 ! | 2000-12-31 17:32:01-08 ! | 2001-01-01 17:32:01-08 ! (66 rows) ! SELECT '' AS eight, f1 AS us_iso FROM ABSTIME_TBL; eight | us_iso -------+------------------------ --- 827,833 ---- SET DateStyle TO 'US,ISO'; SELECT '' AS "66", d1 AS us_iso FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS eight, f1 AS us_iso FROM ABSTIME_TBL; eight | us_iso -------+------------------------ *************** *** 997,1072 **** SHOW DateStyle; NOTICE: DateStyle is SQL with US (NonEuropean) conventions SELECT '' AS "66", d1 AS us_sql FROM TIMESTAMP_TBL; ! 66 | us_sql ! ----+---------------------------- ! | invalid ! | -infinity ! | infinity ! | epoch ! | 02/10/1997 17:32:01.00 PST ! | invalid ! | invalid ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:02.00 PST ! | 02/10/1997 17:32:01.40 PST ! | 02/10/1997 17:32:01.50 PST ! | 02/10/1997 17:32:01.60 PST ! | 01/02/1997 00:00:00.00 PST ! | 01/02/1997 03:04:05.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 06/10/1997 17:32:01.00 PDT ! | 03/15/2000 08:14:01.00 PST ! | 03/15/2000 04:14:02.00 PST ! | 03/15/2000 02:14:03.00 PST ! | 03/15/2000 03:14:04.00 PST ! | 03/15/2000 01:14:05.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:00.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 17:32:01.00 PST ! | 02/10/1997 09:32:01.00 PST ! | 02/10/1997 09:32:01.00 PST ! | 02/10/1997 09:32:01.00 PST ! | 06/10/1997 18:32:01.00 PDT ! | 02/10/1997 17:32:01.00 PST ! | 02/11/1997 17:32:01.00 PST ! | 02/12/1997 17:32:01.00 PST ! | 02/13/1997 17:32:01.00 PST ! | 02/14/1997 17:32:01.00 PST ! | 02/15/1997 17:32:01.00 PST ! | 02/16/1997 17:32:01.00 PST ! | 02/16/0097 17:32 BC ! | 02/16/0097 17:32:01.00 ! | 02/16/0597 17:32:01.00 ! | 02/16/1097 17:32:01.00 ! | 02/16/1697 17:32:01.00 ! | 02/16/1797 17:32:01.00 ! | 02/16/1897 17:32:01.00 ! | 02/16/1997 17:32:01.00 PST ! | 02/16/2097 17:32:01.00 ! | 02/28/1996 17:32:01.00 PST ! | 02/29/1996 17:32:01.00 PST ! | 03/01/1996 17:32:01.00 PST ! | 12/30/1996 17:32:01.00 PST ! | 12/31/1996 17:32:01.00 PST ! | 01/01/1997 17:32:01.00 PST ! | 02/28/1997 17:32:01.00 PST ! | 03/01/1997 17:32:01.00 PST ! | 12/30/1997 17:32:01.00 PST ! | 12/31/1997 17:32:01.00 PST ! | 12/31/1999 17:32:01.00 PST ! | 01/01/2000 17:32:01.00 PST ! | 12/31/2000 17:32:01.00 PST ! | 01/01/2001 17:32:01.00 PST ! (66 rows) ! SELECT '' AS eight, f1 AS us_sql FROM ABSTIME_TBL; eight | us_sql -------+---------------------------- --- 845,851 ---- SHOW DateStyle; NOTICE: DateStyle is SQL with US (NonEuropean) conventions SELECT '' AS "66", d1 AS us_sql FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS eight, f1 AS us_sql FROM ABSTIME_TBL; eight | us_sql -------+---------------------------- *************** *** 1091,1167 **** (1 row) SELECT '' AS "67", d1 AS european_postgres FROM TIMESTAMP_TBL; ! 67 | european_postgres ! ----+--------------------------------- ! | invalid ! | -infinity ! | infinity ! | epoch ! | Mon 10 Feb 17:32:01 1997 PST ! | invalid ! | invalid ! | Mon 10 Feb 17:32:01.00 1997 PST ! | Mon 10 Feb 17:32:02.00 1997 PST ! | Mon 10 Feb 17:32:01.40 1997 PST ! | Mon 10 Feb 17:32:01.50 1997 PST ! | Mon 10 Feb 17:32:01.60 1997 PST ! | Thu 02 Jan 00:00:00 1997 PST ! | Thu 02 Jan 03:04:05 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Tue 10 Jun 17:32:01 1997 PDT ! | Wed 15 Mar 08:14:01 2000 PST ! | Wed 15 Mar 04:14:02 2000 PST ! | Wed 15 Mar 02:14:03 2000 PST ! | Wed 15 Mar 03:14:04 2000 PST ! | Wed 15 Mar 01:14:05 2000 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:00 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 17:32:01 1997 PST ! | Mon 10 Feb 09:32:01 1997 PST ! | Mon 10 Feb 09:32:01 1997 PST ! | Mon 10 Feb 09:32:01 1997 PST ! | Tue 10 Jun 18:32:01 1997 PDT ! | Mon 10 Feb 17:32:01 1997 PST ! | Tue 11 Feb 17:32:01 1997 PST ! | Wed 12 Feb 17:32:01 1997 PST ! | Thu 13 Feb 17:32:01 1997 PST ! | Fri 14 Feb 17:32:01 1997 PST ! | Sat 15 Feb 17:32:01 1997 PST ! | Sun 16 Feb 17:32:01 1997 PST ! | Tue 16 Feb 17:32 0097 BC ! | Sat 16 Feb 17:32:01 0097 ! | Thu 16 Feb 17:32:01 0597 ! | Tue 16 Feb 17:32:01 1097 ! | Sat 16 Feb 17:32:01 1697 ! | Thu 16 Feb 17:32:01 1797 ! | Tue 16 Feb 17:32:01 1897 ! | Sun 16 Feb 17:32:01 1997 PST ! | Sat 16 Feb 17:32:01 2097 ! | Wed 28 Feb 17:32:01 1996 PST ! | Thu 29 Feb 17:32:01 1996 PST ! | Fri 01 Mar 17:32:01 1996 PST ! | Mon 30 Dec 17:32:01 1996 PST ! | Tue 31 Dec 17:32:01 1996 PST ! | Wed 01 Jan 17:32:01 1997 PST ! | Fri 28 Feb 17:32:01 1997 PST ! | Sat 01 Mar 17:32:01 1997 PST ! | Tue 30 Dec 17:32:01 1997 PST ! | Wed 31 Dec 17:32:01 1997 PST ! | Fri 31 Dec 17:32:01 1999 PST ! | Sat 01 Jan 17:32:01 2000 PST ! | Sun 31 Dec 17:32:01 2000 PST ! | Mon 01 Jan 17:32:01 2001 PST ! | Thu 13 Jun 00:00:00 1957 PDT ! (67 rows) ! SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL; eight | european_postgres -------+------------------------------ --- 870,876 ---- (1 row) SELECT '' AS "67", d1 AS european_postgres FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL; eight | european_postgres -------+------------------------------ *************** *** 1179,1255 **** SHOW DateStyle; NOTICE: DateStyle is ISO with European conventions SELECT '' AS "67", d1 AS european_iso FROM TIMESTAMP_TBL; ! 67 | european_iso ! ----+--------------------------- ! | invalid ! | -infinity ! | infinity ! | epoch ! | 1997-02-10 17:32:01-08 ! | invalid ! | invalid ! | 1997-02-10 17:32:01.00-08 ! | 1997-02-10 17:32:02.00-08 ! | 1997-02-10 17:32:01.40-08 ! | 1997-02-10 17:32:01.50-08 ! | 1997-02-10 17:32:01.60-08 ! | 1997-01-02 00:00:00-08 ! | 1997-01-02 03:04:05-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-06-10 17:32:01-07 ! | 2000-03-15 08:14:01-08 ! | 2000-03-15 04:14:02-08 ! | 2000-03-15 02:14:03-08 ! | 2000-03-15 03:14:04-08 ! | 2000-03-15 01:14:05-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:00-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 17:32:01-08 ! | 1997-02-10 09:32:01-08 ! | 1997-02-10 09:32:01-08 ! | 1997-02-10 09:32:01-08 ! | 1997-06-10 18:32:01-07 ! | 1997-02-10 17:32:01-08 ! | 1997-02-11 17:32:01-08 ! | 1997-02-12 17:32:01-08 ! | 1997-02-13 17:32:01-08 ! | 1997-02-14 17:32:01-08 ! | 1997-02-15 17:32:01-08 ! | 1997-02-16 17:32:01-08 ! | 0097-02-16 17:32 BC ! | 0097-02-16 17:32:01 ! | 0597-02-16 17:32:01 ! | 1097-02-16 17:32:01 ! | 1697-02-16 17:32:01 ! | 1797-02-16 17:32:01 ! | 1897-02-16 17:32:01 ! | 1997-02-16 17:32:01-08 ! | 2097-02-16 17:32:01 ! | 1996-02-28 17:32:01-08 ! | 1996-02-29 17:32:01-08 ! | 1996-03-01 17:32:01-08 ! | 1996-12-30 17:32:01-08 ! | 1996-12-31 17:32:01-08 ! | 1997-01-01 17:32:01-08 ! | 1997-02-28 17:32:01-08 ! | 1997-03-01 17:32:01-08 ! | 1997-12-30 17:32:01-08 ! | 1997-12-31 17:32:01-08 ! | 1999-12-31 17:32:01-08 ! | 2000-01-01 17:32:01-08 ! | 2000-12-31 17:32:01-08 ! | 2001-01-01 17:32:01-08 ! | 1957-06-13 00:00:00-07 ! (67 rows) ! SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL; eight | european_iso -------+------------------------ --- 888,894 ---- SHOW DateStyle; NOTICE: DateStyle is ISO with European conventions SELECT '' AS "67", d1 AS european_iso FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL; eight | european_iso -------+------------------------ *************** *** 1267,1343 **** SHOW DateStyle; NOTICE: DateStyle is SQL with European conventions SELECT '' AS "67", d1 AS european_sql FROM TIMESTAMP_TBL; ! 67 | european_sql ! ----+---------------------------- ! | invalid ! | -infinity ! | infinity ! | epoch ! | 10/02/1997 17:32:01.00 PST ! | invalid ! | invalid ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:02.00 PST ! | 10/02/1997 17:32:01.40 PST ! | 10/02/1997 17:32:01.50 PST ! | 10/02/1997 17:32:01.60 PST ! | 02/01/1997 00:00:00.00 PST ! | 02/01/1997 03:04:05.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/06/1997 17:32:01.00 PDT ! | 15/03/2000 08:14:01.00 PST ! | 15/03/2000 04:14:02.00 PST ! | 15/03/2000 02:14:03.00 PST ! | 15/03/2000 03:14:04.00 PST ! | 15/03/2000 01:14:05.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:00.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 17:32:01.00 PST ! | 10/02/1997 09:32:01.00 PST ! | 10/02/1997 09:32:01.00 PST ! | 10/02/1997 09:32:01.00 PST ! | 10/06/1997 18:32:01.00 PDT ! | 10/02/1997 17:32:01.00 PST ! | 11/02/1997 17:32:01.00 PST ! | 12/02/1997 17:32:01.00 PST ! | 13/02/1997 17:32:01.00 PST ! | 14/02/1997 17:32:01.00 PST ! | 15/02/1997 17:32:01.00 PST ! | 16/02/1997 17:32:01.00 PST ! | 16/02/0097 17:32 BC ! | 16/02/0097 17:32:01.00 ! | 16/02/0597 17:32:01.00 ! | 16/02/1097 17:32:01.00 ! | 16/02/1697 17:32:01.00 ! | 16/02/1797 17:32:01.00 ! | 16/02/1897 17:32:01.00 ! | 16/02/1997 17:32:01.00 PST ! | 16/02/2097 17:32:01.00 ! | 28/02/1996 17:32:01.00 PST ! | 29/02/1996 17:32:01.00 PST ! | 01/03/1996 17:32:01.00 PST ! | 30/12/1996 17:32:01.00 PST ! | 31/12/1996 17:32:01.00 PST ! | 01/01/1997 17:32:01.00 PST ! | 28/02/1997 17:32:01.00 PST ! | 01/03/1997 17:32:01.00 PST ! | 30/12/1997 17:32:01.00 PST ! | 31/12/1997 17:32:01.00 PST ! | 31/12/1999 17:32:01.00 PST ! | 01/01/2000 17:32:01.00 PST ! | 31/12/2000 17:32:01.00 PST ! | 01/01/2001 17:32:01.00 PST ! | 13/06/1957 00:00:00.00 PDT ! (67 rows) ! SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL; eight | european_sql -------+---------------------------- --- 906,912 ---- SHOW DateStyle; NOTICE: DateStyle is SQL with European conventions SELECT '' AS "67", d1 AS european_sql FROM TIMESTAMP_TBL; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL; eight | european_sql -------+---------------------------- ----------------------