diff options
Diffstat (limited to 'src/test/regress/queries.source')
| -rw-r--r-- | src/test/regress/queries.source | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/src/test/regress/queries.source b/src/test/regress/queries.source index 1e98570479..5b23c59201 100644 --- a/src/test/regress/queries.source +++ b/src/test/regress/queries.source @@ -1,7 +1,7 @@ -- -- queries.source -- --- $Header: /cvsroot/pgsql/src/test/regress/Attic/queries.source,v 1.4 1996/11/14 16:09:26 momjian Exp $ +-- $Header: /cvsroot/pgsql/src/test/regress/Attic/queries.source,v 1.5 1996/12/02 06:31:20 momjian Exp $ -- -- The comments that contain sequences of UNIX commands generate the -- desired output for the POSTQUEL statement(s). @@ -115,7 +115,7 @@ CREATE TABLE ABSTIME_TBL (f1 abstime); INSERT INTO ABSTIME_TBL (f1) VALUES ('Jan 14, 1973 03:14:21'); -- was INSERT INTO ABSTIME_TBL (f1) VALUES ('now'::abstime): -INSERT INTO ABSTIME_TBL (f1) VALUES ('Mon May 1 00:30:30 PDT 1995'::abstime); +INSERT INTO ABSTIME_TBL (f1) VALUES ('Mon May 1 00:30:30 1995'::abstime); INSERT INTO ABSTIME_TBL (f1) VALUES ('epoch'::abstime); @@ -173,7 +173,7 @@ INSERT INTO TINTERVAL_TBL (f1) VALUES ('["Sep 4, 1983 23:59:12" "Oct 4, 1983 23:59:12"]'); INSERT INTO TINTERVAL_TBL (f1) - VALUES ('["epoch" "Mon May 1 00:30:30 PDT 1995"]'); + VALUES ('["epoch" "Mon May 1 00:30:30 1995"]'); INSERT INTO TINTERVAL_TBL (f1) VALUES ('["Feb 15 1990 12:15:03" "current"]'); @@ -218,7 +218,7 @@ SELECT '' AS six, ABSTIME_TBL.* -- the "infinity" and "-infinity" tuples in ABSTIME_TBL cannot be added and -- therefore, should not show up in the results. SELECT '' AS five, ABSTIME_TBL.* - WHERE (ABSTIME_TBL.f1 + '@ 3 year'::reltime) -- +3 years + WHERE (ABSTIME_TBL.f1 + '@ 3 year'::reltime) -- +3 years < 'Jan 14 14:00:00 1977'::abstime; SELECT '' AS five, ABSTIME_TBL.* @@ -226,11 +226,11 @@ SELECT '' AS five, ABSTIME_TBL.* < 'Jan 14 14:00:00 1971'::abstime; SELECT '' AS five, ABSTIME_TBL.* - WHERE (ABSTIME_TBL.f1 - '@ 3 year'::reltime) -- -(+3) years + WHERE (ABSTIME_TBL.f1 - '@ 3 year'::reltime) -- -(+3) years < 'Jan 14 14:00:00 1971'::abstime; SELECT '' AS five, ABSTIME_TBL.* - WHERE (ABSTIME_TBL.f1 - '@ 3 year ago'::reltime) -- -(-3) years + WHERE (ABSTIME_TBL.f1 - '@ 3 year ago'::reltime) -- -(-3) years < 'Jan 14 14:00:00 1977'::abstime; @@ -2273,7 +2273,7 @@ ALTER TABLE temp ADD COLUMN z int2[]; INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, v, w, x, y, z) VALUES (4, 'char16', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)', - 'Mon May 1 00:30:30 PDT 1995', 'c', '{Mon May 1 00:30:30 PDT 1995, Monday Aug 24 14:43:07 1992 PDT, epoch}', + 'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}', 314159, '(1,1)', 512, '1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)', '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]', @@ -2342,7 +2342,7 @@ ALTER TABLE temp ADD COLUMN z int2[]; INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, v, w, x, y, z) VALUES (4, 'char16', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)', - 'Mon May 1 00:30:30 PDT 1995', 'c', '{Mon May 1 00:30:30 PDT 1995, Monday Aug 24 14:43:07 1992 PDT, epoch}', + 'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}', 314159, '(1,1)', 512, '1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)', '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]', |