diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-11-06 20:12:20 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-11-06 20:12:20 -0500 |
| commit | f62be400c0e2369d68b4327ced721e47250dc40c (patch) | |
| tree | 4e20bd314d5f836808c7deab83d1a2801cc53b95 /src | |
| parent | 362f731dde94b10f8a01e80fddd2bf99c4f66587 (diff) | |
| download | postgresql-f62be400c0e2369d68b4327ced721e47250dc40c.tar.gz postgresql-f62be400c0e2369d68b4327ced721e47250dc40c.zip | |
On second thought, we'd better just drop these tests altogether.
Further experimentation reveals that my previous change didn't fix the
issue entirely: these tests would still fail at the spring-forward DST
transition. There doesn't seem to be any great value in testing this
specific issue for both timestamp and timestamptz, so just lose the
latter tests.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/horology.out | 42 | ||||
| -rw-r--r-- | src/test/regress/sql/horology.sql | 7 |
2 files changed, 0 insertions, 49 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index 6a08fbfd6fb..553a158e2c7 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -639,54 +639,12 @@ SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' t (1 row) -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-08 today' = timestamptz(date 'today', time with time zone '10:30 -08')) as "True"; - True ------- - t -(1 row) - SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True"; True ------ t (1 row) -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-08 tomorrow' = (timestamp with time zone 'today 10:30-08' + interval '1 day')) as "True"; - True ------- - t -(1 row) - -SELECT (timestamp with time zone 'yesterday 12:34:56-7' = timestamptz(date 'yesterday', time with time zone '12:34:56-7')) as "True"; - True ------- - t -(1 row) - -SELECT (timestamp with time zone '12:34:56 yesterday -7' = timestamptz(date 'yesterday', time with time zone '12:34:56-7')) as "True"; - True ------- - t -(1 row) - -SELECT (timestamp with time zone '12:34:56-7 yesterday' = timestamptz(date 'yesterday', time with time zone '12:34:56-7')) as "True"; - True ------- - t -(1 row) - SELECT (timestamp with time zone 'tomorrow' > 'now') as "True"; True ------ diff --git a/src/test/regress/sql/horology.sql b/src/test/regress/sql/horology.sql index 90e1bec4e4e..ea794ecdd93 100644 --- a/src/test/regress/sql/horology.sql +++ b/src/test/regress/sql/horology.sql @@ -118,14 +118,7 @@ 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-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-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"; SELECT (timestamp with time zone 'tomorrow' > 'now') as "True"; -- timestamp with time zone, interval arithmetic around DST change |