diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 2000-11-11 19:57:03 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 2000-11-11 19:57:03 +0000 |
| commit | b9c8faeddeca61c17e46db757be376eb854f4434 (patch) | |
| tree | 378cf42aee03cfe853ef4b4d6115caac85e59347 | |
| parent | d74c52c357792d591fa56d1fa92979fb715fbb60 (diff) | |
| download | postgresql-b9c8faeddeca61c17e46db757be376eb854f4434.tar.gz postgresql-b9c8faeddeca61c17e46db757be376eb854f4434.zip | |
Allow more timezone-like interpretation of INTERVALs.
Fix up labeling of some new test cases.
| -rw-r--r-- | src/test/regress/sql/interval.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/test/regress/sql/interval.sql b/src/test/regress/sql/interval.sql index f4ca0a7371b..945eb08d605 100644 --- a/src/test/regress/sql/interval.sql +++ b/src/test/regress/sql/interval.sql @@ -5,13 +5,13 @@ SET DATESTYLE = DEFAULT; -- check acceptance of "time zone style" -SELECT INTERVAL '01:00'; -SELECT INTERVAL '+02:00'; -SELECT INTERVAL '-08:00'; -SELECT INTERVAL '-05'; -SELECT INTERVAL '-1 +02:03'; -SELECT INTERVAL '-1 days +02:03'; -SELECT INTERVAL '10 years -11 month -12 days +13:14'; +SELECT INTERVAL '01:00' AS "One hour"; +SELECT INTERVAL '+02:00' AS "Two hours"; +SELECT INTERVAL '-08:00' AS "Eight hours"; +SELECT INTERVAL '-05' AS "Five hours"; +SELECT INTERVAL '-1 +02:03' AS "22 hours ago..."; +SELECT INTERVAL '-1 days +02:03' AS "22 hours ago..."; +SELECT INTERVAL '10 years -11 month -12 days +13:14' AS "9 years..."; CREATE TABLE INTERVAL_TBL (f1 interval); |