From b9c8faeddeca61c17e46db757be376eb854f4434 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Sat, 11 Nov 2000 19:57:03 +0000 Subject: [PATCH] Allow more timezone-like interpretation of INTERVALs. Fix up labeling of some new test cases. --- src/test/regress/sql/interval.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/src/test/regress/sql/interval.sql b/src/test/regress/sql/interval.sql index f4ca0a7371..945eb08d60 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); -- 2.40.0