aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2011-11-06 18:20:26 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2011-11-06 18:20:26 -0500
commit362f731dde94b10f8a01e80fddd2bf99c4f66587 (patch)
tree3ee6d402a30359c7d6c73c0f0564769b43303204
parent780571cc9fcfc1d2c4a0212c19975f2ef0b2eb42 (diff)
downloadpostgresql-362f731dde94b10f8a01e80fddd2bf99c4f66587.tar.gz
postgresql-362f731dde94b10f8a01e80fddd2bf99c4f66587.zip
Un-break horology regression test.
Adjust ill-considered timezone-dependent tests added in commit 8a3d33c8e6c681d512f79af4a521ee0c02befcef so that they won't fail on DST transition days. Per all-pink buildfarm.
-rw-r--r--src/test/regress/expected/horology.out8
-rw-r--r--src/test/regress/sql/horology.sql8
2 files changed, 8 insertions, 8 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out
index 8526765967c..6a08fbfd6fb 100644
--- a/src/test/regress/expected/horology.out
+++ b/src/test/regress/expected/horology.out
@@ -639,13 +639,13 @@ SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow'
t
(1 row)
-SELECT (timestamp with time zone 'today 10:30+05' = timestamptz(date 'today', time with time zone '10:30 +05')) as "True";
+SELECT (timestamp with time zone 'today 10:30-08' = timestamptz(date 'today', time with time zone '10:30 -08')) as "True";
True
------
t
(1 row)
-SELECT (timestamp with time zone '10:30+05 today' = timestamptz(date 'today', time with time zone '10:30 +05')) as "True";
+SELECT (timestamp with time zone '10:30-08 today' = timestamptz(date 'today', time with time zone '10:30 -08')) as "True";
True
------
t
@@ -657,13 +657,13 @@ SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterd
t
(1 row)
-SELECT (timestamp with time zone 'tomorrow 10:30+05' = (timestamp with time zone 'today 10:30+05' + interval '1 day')) as "True";
+SELECT (timestamp with time zone 'tomorrow 10:30-08' = (timestamp with time zone 'today 10:30-08' + interval '1 day')) as "True";
True
------
t
(1 row)
-SELECT (timestamp with time zone '10:30+05 tomorrow' = (timestamp with time zone 'today 10:30+05' + interval '1 day')) as "True";
+SELECT (timestamp with time zone '10:30-08 tomorrow' = (timestamp with time zone 'today 10:30-08' + interval '1 day')) as "True";
True
------
t
diff --git a/src/test/regress/sql/horology.sql b/src/test/regress/sql/horology.sql
index e9981e586a5..90e1bec4e4e 100644
--- a/src/test/regress/sql/horology.sql
+++ b/src/test/regress/sql/horology.sql
@@ -118,11 +118,11 @@ SELECT timestamp with time zone '1999-12-01' + interval '1 month - 1 second' AS
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
-SELECT (timestamp with time zone 'today 10:30+05' = timestamptz(date 'today', time with time zone '10:30 +05')) as "True";
-SELECT (timestamp with time zone '10:30+05 today' = timestamptz(date 'today', time with time zone '10:30 +05')) as "True";
+SELECT (timestamp with time zone 'today 10:30-08' = timestamptz(date 'today', time with time zone '10:30 -08')) as "True";
+SELECT (timestamp with time zone '10:30-08 today' = timestamptz(date 'today', time with time zone '10:30 -08')) as "True";
SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
-SELECT (timestamp with time zone 'tomorrow 10:30+05' = (timestamp with time zone 'today 10:30+05' + interval '1 day')) as "True";
-SELECT (timestamp with time zone '10:30+05 tomorrow' = (timestamp with time zone 'today 10:30+05' + interval '1 day')) as "True";
+SELECT (timestamp with time zone 'tomorrow 10:30-08' = (timestamp with time zone 'today 10:30-08' + interval '1 day')) as "True";
+SELECT (timestamp with time zone '10:30-08 tomorrow' = (timestamp with time zone 'today 10:30-08' + interval '1 day')) as "True";
SELECT (timestamp with time zone 'yesterday 12:34:56-7' = timestamptz(date 'yesterday', time with time zone '12:34:56-7')) as "True";
SELECT (timestamp with time zone '12:34:56 yesterday -7' = timestamptz(date 'yesterday', time with time zone '12:34:56-7')) as "True";
SELECT (timestamp with time zone '12:34:56-7 yesterday' = timestamptz(date 'yesterday', time with time zone '12:34:56-7')) as "True";