diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 2001-10-31 14:44:23 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 2001-10-31 14:44:23 +0000 |
| commit | c859ff92d05f85d8378139db812315a63c954975 (patch) | |
| tree | b69618be37e953ffcf42bb47d4a61edb5f42f852 /src | |
| parent | 57584d70fa1b2f1ade9f3ce6bd68408f5754dfe1 (diff) | |
| download | postgresql-c859ff92d05f85d8378139db812315a63c954975.tar.gz postgresql-c859ff92d05f85d8378139db812315a63c954975.zip | |
Fix queries to insulate from daylight savings time.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/timetz.out | 8 | ||||
| -rw-r--r-- | src/test/regress/sql/timetz.sql | 8 |
2 files changed, 8 insertions, 8 deletions
diff --git a/src/test/regress/expected/timetz.out b/src/test/regress/expected/timetz.out index ddc785cc4fb..62e5c19f003 100644 --- a/src/test/regress/expected/timetz.out +++ b/src/test/regress/expected/timetz.out @@ -27,7 +27,7 @@ SELECT f1 AS "Time TZ" FROM TIMETZ_TBL; 23:59:59.99-07 (10 rows) -SELECT f1 AS "Three" FROM TIMETZ_TBL WHERE f1 < '05:06:07'; +SELECT f1 AS "Three" FROM TIMETZ_TBL WHERE f1 < '05:06:07-07'; Three ------------- 00:01:00-07 @@ -35,7 +35,7 @@ SELECT f1 AS "Three" FROM TIMETZ_TBL WHERE f1 < '05:06:07'; 02:03:00-07 (3 rows) -SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07'; +SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07-07'; Seven ---------------- 07:07:00-08 @@ -47,12 +47,12 @@ SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07'; 23:59:59.99-07 (7 rows) -SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00'; +SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00-07'; None ------ (0 rows) -SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00'; +SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00-07'; Ten ---------------- 00:01:00-07 diff --git a/src/test/regress/sql/timetz.sql b/src/test/regress/sql/timetz.sql index a8428270596..24f34cb31a2 100644 --- a/src/test/regress/sql/timetz.sql +++ b/src/test/regress/sql/timetz.sql @@ -17,13 +17,13 @@ INSERT INTO TIMETZ_TBL VALUES ('11:59:59.99 PM PDT'); SELECT f1 AS "Time TZ" FROM TIMETZ_TBL; -SELECT f1 AS "Three" FROM TIMETZ_TBL WHERE f1 < '05:06:07'; +SELECT f1 AS "Three" FROM TIMETZ_TBL WHERE f1 < '05:06:07-07'; -SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07'; +SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07-07'; -SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00'; +SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00-07'; -SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00'; +SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00-07'; -- -- TIME simple math |