aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/timetz.out8
-rw-r--r--src/test/regress/sql/timetz.sql8
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