aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorThomas G. Lockhart <lockhart@fourpalms.org>2000-11-11 19:56:43 +0000
committerThomas G. Lockhart <lockhart@fourpalms.org>2000-11-11 19:56:43 +0000
commitd74c52c357792d591fa56d1fa92979fb715fbb60 (patch)
treef4de77f3e2ab15d487c5696f47a5a7130af2ebf6
parenta669bd74eec487202c08093c7dfc6b245a43abb7 (diff)
downloadpostgresql-d74c52c357792d591fa56d1fa92979fb715fbb60.tar.gz
postgresql-d74c52c357792d591fa56d1fa92979fb715fbb60.zip
Allow more timezone-like interpretation of INTERVALs.
-rw-r--r--src/test/regress/expected/interval.out40
1 files changed, 20 insertions, 20 deletions
diff --git a/src/test/regress/expected/interval.out b/src/test/regress/expected/interval.out
index a8ea6c24d7d..d76c922a141 100644
--- a/src/test/regress/expected/interval.out
+++ b/src/test/regress/expected/interval.out
@@ -3,44 +3,44 @@
--
SET DATESTYLE = DEFAULT;
-- check acceptance of "time zone style"
-SELECT INTERVAL '01:00';
- ?column?
+SELECT INTERVAL '01:00' AS "One hour";
+ One hour
----------
+01:00
(1 row)
-SELECT INTERVAL '+02:00';
- ?column?
-----------
+SELECT INTERVAL '+02:00' AS "Two hours";
+ Two hours
+-----------
+02:00
(1 row)
-SELECT INTERVAL '-08:00';
- ?column?
-----------
+SELECT INTERVAL '-08:00' AS "Eight hours";
+ Eight hours
+-------------
-08:00
(1 row)
-SELECT INTERVAL '-05';
- ?column?
------------
- -00:00:05
+SELECT INTERVAL '-05' AS "Five hours";
+ Five hours
+------------
+ -05:00
(1 row)
-SELECT INTERVAL '-1 +02:03';
- ?column?
-----------
+SELECT INTERVAL '-1 +02:03' AS "22 hours ago...";
+ 22 hours ago...
+-----------------
-21:57
(1 row)
-SELECT INTERVAL '-1 days +02:03';
- ?column?
-----------
+SELECT INTERVAL '-1 days +02:03' AS "22 hours ago...";
+ 22 hours ago...
+-----------------
-21:57
(1 row)
-SELECT INTERVAL '10 years -11 month -12 days +13:14';
- ?column?
+SELECT INTERVAL '10 years -11 month -12 days +13:14' AS "9 years...";
+ 9 years...
--------------------------
9 years 1 mon -11 -10:46
(1 row)