diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-04-02 19:39:54 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-04-02 19:39:54 +0000 |
| commit | 23a1f015e533210b0c5b63bf24955c2e57d86a26 (patch) | |
| tree | d88771f8c4691b9bb108061626a75340ff7d8557 /src | |
| parent | f7ae90041ef16e2e1a5296b0cc6fed1202acf312 (diff) | |
| download | postgresql-23a1f015e533210b0c5b63bf24955c2e57d86a26.tar.gz postgresql-23a1f015e533210b0c5b63bf24955c2e57d86a26.zip | |
Adjust interval-addition test so that it won't fail on DST transition days.
Strange that we missed this DST dependence while fixing the others.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/horology.out | 8 | ||||
| -rw-r--r-- | src/test/regress/sql/horology.sql | 4 |
2 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index ea22c443861..98af32ec527 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -855,11 +855,11 @@ SELECT time with time zone '02:30-08' + interval '36:01' AS "14:31:00-08"; -- SELECT time with time zone '01:30' + interval '02:01' AS "03:31:00-08"; -- SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08"; -- Try the following two tests instead, as a poor substitute -SELECT CAST(CAST(date 'today' + time with time zone '01:30' - + interval '02:01' AS time with time zone) AS time) AS "03:31:00"; - 03:31:00 +SELECT CAST(CAST(date 'today' + time with time zone '05:30' + + interval '02:01' AS time with time zone) AS time) AS "07:31:00"; + 07:31:00 ---------- - 03:31:00 + 07:31:00 (1 row) SELECT CAST(cast(date 'today' + time with time zone '03:30' diff --git a/src/test/regress/sql/horology.sql b/src/test/regress/sql/horology.sql index d4be1f51d5e..922b511a864 100644 --- a/src/test/regress/sql/horology.sql +++ b/src/test/regress/sql/horology.sql @@ -153,8 +153,8 @@ SELECT time with time zone '02:30-08' + interval '36:01' AS "14:31:00-08"; -- SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08"; -- Try the following two tests instead, as a poor substitute -SELECT CAST(CAST(date 'today' + time with time zone '01:30' - + interval '02:01' AS time with time zone) AS time) AS "03:31:00"; +SELECT CAST(CAST(date 'today' + time with time zone '05:30' + + interval '02:01' AS time with time zone) AS time) AS "07:31:00"; SELECT CAST(cast(date 'today' + time with time zone '03:30' + interval '1 month 04:01' as timestamp without time zone) AS time) AS "07:31:00"; |