aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2007-07-25 17:22:37 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2007-07-25 17:22:37 +0000
commit3eb98fd16550304a9508c3e0ceac435647f672c9 (patch)
tree8741c6ed14e04e2322f02644ae320aac6a1ab5bc
parenta1b336679c8a263525e4bfa6786c931ff5be0d8d (diff)
downloadpostgresql-3eb98fd16550304a9508c3e0ceac435647f672c9.tar.gz
postgresql-3eb98fd16550304a9508c3e0ceac435647f672c9.zip
Adjust horology test to avoid join-plan-dependent result ordering in
a few queries. Should fix buildfarm failures arising from new, more aggressive autovac settings.
-rw-r--r--src/test/regress/expected/horology.out1015
-rw-r--r--src/test/regress/sql/horology.sql20
2 files changed, 350 insertions, 685 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out
index fb4f33ed6b1..9c101ad9a0e 100644
--- a/src/test/regress/expected/horology.out
+++ b/src/test/regress/expected/horology.out
@@ -877,686 +877,351 @@ SELECT CAST(cast(date 'today' + time with time zone '03:30'
07:31:00
(1 row)
-SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
+SELECT t.d1 AS t, i.f1 AS i, t.d1 + i.f1 AS "add", t.d1 - i.f1 AS "subtract"
+ FROM TIMESTAMP_TBL t, INTERVAL_TBL i
WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
- AND i.f1 BETWEEN '00:00' AND '23:00';
- 102
------------------------------
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:02 1997
- Mon Feb 10 22:32:02 1997
- Mon Feb 10 17:33:01.40 1997
- Mon Feb 10 22:32:01.40 1997
- Mon Feb 10 17:33:01.50 1997
- Mon Feb 10 22:32:01.50 1997
- Mon Feb 10 17:33:01.60 1997
- Mon Feb 10 22:32:01.60 1997
- Thu Jan 02 00:01:00 1997
- Thu Jan 02 05:00:00 1997
- Thu Jan 02 03:05:05 1997
- Thu Jan 02 08:04:05 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Tue Jun 10 17:33:01 1997
- Tue Jun 10 22:32:01 1997
- Wed Mar 15 08:15:01 2000
- Wed Mar 15 13:14:01 2000
- Wed Mar 15 13:15:02 2000
- Wed Mar 15 18:14:02 2000
- Wed Mar 15 12:15:03 2000
- Wed Mar 15 17:14:03 2000
- Wed Mar 15 03:15:04 2000
- Wed Mar 15 08:14:04 2000
- Wed Mar 15 02:15:05 2000
- Wed Mar 15 07:14:05 2000
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:00 1997
- Mon Feb 10 22:32:00 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Tue Jun 10 18:33:01 1997
- Tue Jun 10 23:32:01 1997
- Mon Feb 10 17:33:01 1997
- Mon Feb 10 22:32:01 1997
- Tue Feb 11 17:33:01 1997
- Tue Feb 11 22:32:01 1997
- Wed Feb 12 17:33:01 1997
- Wed Feb 12 22:32:01 1997
- Thu Feb 13 17:33:01 1997
- Thu Feb 13 22:32:01 1997
- Fri Feb 14 17:33:01 1997
- Fri Feb 14 22:32:01 1997
- Sat Feb 15 17:33:01 1997
- Sat Feb 15 22:32:01 1997
- Sun Feb 16 17:33:01 1997
- Sun Feb 16 22:32:01 1997
- Sun Feb 16 17:33:01 1997
- Sun Feb 16 22:32:01 1997
- Wed Feb 28 17:33:01 1996
- Wed Feb 28 22:32:01 1996
- Thu Feb 29 17:33:01 1996
- Thu Feb 29 22:32:01 1996
- Fri Mar 01 17:33:01 1996
- Fri Mar 01 22:32:01 1996
- Mon Dec 30 17:33:01 1996
- Mon Dec 30 22:32:01 1996
- Tue Dec 31 17:33:01 1996
- Tue Dec 31 22:32:01 1996
- Wed Jan 01 17:33:01 1997
- Wed Jan 01 22:32:01 1997
- Fri Feb 28 17:33:01 1997
- Fri Feb 28 22:32:01 1997
- Sat Mar 01 17:33:01 1997
- Sat Mar 01 22:32:01 1997
- Tue Dec 30 17:33:01 1997
- Tue Dec 30 22:32:01 1997
- Wed Dec 31 17:33:01 1997
- Wed Dec 31 22:32:01 1997
- Fri Dec 31 17:33:01 1999
- Fri Dec 31 22:32:01 1999
- Sat Jan 01 17:33:01 2000
- Sat Jan 01 22:32:01 2000
- Sun Dec 31 17:33:01 2000
- Sun Dec 31 22:32:01 2000
-(104 rows)
-
-SELECT t.d1 - i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
- WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
- AND i.f1 BETWEEN '00:00' AND '23:00';
- 102
------------------------------
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:02 1997
- Mon Feb 10 12:32:02 1997
- Mon Feb 10 17:31:01.40 1997
- Mon Feb 10 12:32:01.40 1997
- Mon Feb 10 17:31:01.50 1997
- Mon Feb 10 12:32:01.50 1997
- Mon Feb 10 17:31:01.60 1997
- Mon Feb 10 12:32:01.60 1997
- Wed Jan 01 23:59:00 1997
- Wed Jan 01 19:00:00 1997
- Thu Jan 02 03:03:05 1997
- Wed Jan 01 22:04:05 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Tue Jun 10 17:31:01 1997
- Tue Jun 10 12:32:01 1997
- Wed Mar 15 08:13:01 2000
- Wed Mar 15 03:14:01 2000
- Wed Mar 15 13:13:02 2000
- Wed Mar 15 08:14:02 2000
- Wed Mar 15 12:13:03 2000
- Wed Mar 15 07:14:03 2000
- Wed Mar 15 03:13:04 2000
- Tue Mar 14 22:14:04 2000
- Wed Mar 15 02:13:05 2000
- Tue Mar 14 21:14:05 2000
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:00 1997
- Mon Feb 10 12:32:00 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Tue Jun 10 18:31:01 1997
- Tue Jun 10 13:32:01 1997
- Mon Feb 10 17:31:01 1997
- Mon Feb 10 12:32:01 1997
- Tue Feb 11 17:31:01 1997
- Tue Feb 11 12:32:01 1997
- Wed Feb 12 17:31:01 1997
- Wed Feb 12 12:32:01 1997
- Thu Feb 13 17:31:01 1997
- Thu Feb 13 12:32:01 1997
- Fri Feb 14 17:31:01 1997
- Fri Feb 14 12:32:01 1997
- Sat Feb 15 17:31:01 1997
- Sat Feb 15 12:32:01 1997
- Sun Feb 16 17:31:01 1997
- Sun Feb 16 12:32:01 1997
- Sun Feb 16 17:31:01 1997
- Sun Feb 16 12:32:01 1997
- Wed Feb 28 17:31:01 1996
- Wed Feb 28 12:32:01 1996
- Thu Feb 29 17:31:01 1996
- Thu Feb 29 12:32:01 1996
- Fri Mar 01 17:31:01 1996
- Fri Mar 01 12:32:01 1996
- Mon Dec 30 17:31:01 1996
- Mon Dec 30 12:32:01 1996
- Tue Dec 31 17:31:01 1996
- Tue Dec 31 12:32:01 1996
- Wed Jan 01 17:31:01 1997
- Wed Jan 01 12:32:01 1997
- Fri Feb 28 17:31:01 1997
- Fri Feb 28 12:32:01 1997
- Sat Mar 01 17:31:01 1997
- Sat Mar 01 12:32:01 1997
- Tue Dec 30 17:31:01 1997
- Tue Dec 30 12:32:01 1997
- Wed Dec 31 17:31:01 1997
- Wed Dec 31 12:32:01 1997
- Fri Dec 31 17:31:01 1999
- Fri Dec 31 12:32:01 1999
- Sat Jan 01 17:31:01 2000
- Sat Jan 01 12:32:01 2000
- Sun Dec 31 17:31:01 2000
- Sun Dec 31 12:32:01 2000
+ AND i.f1 BETWEEN '00:00' AND '23:00'
+ ORDER BY 1,2;
+ t | i | add | subtract
+-----------------------------+-----------+-----------------------------+-----------------------------
+ Wed Feb 28 17:32:01 1996 | @ 1 min | Wed Feb 28 17:33:01 1996 | Wed Feb 28 17:31:01 1996
+ Wed Feb 28 17:32:01 1996 | @ 5 hours | Wed Feb 28 22:32:01 1996 | Wed Feb 28 12:32:01 1996
+ Thu Feb 29 17:32:01 1996 | @ 1 min | Thu Feb 29 17:33:01 1996 | Thu Feb 29 17:31:01 1996
+ Thu Feb 29 17:32:01 1996 | @ 5 hours | Thu Feb 29 22:32:01 1996 | Thu Feb 29 12:32:01 1996
+ Fri Mar 01 17:32:01 1996 | @ 1 min | Fri Mar 01 17:33:01 1996 | Fri Mar 01 17:31:01 1996
+ Fri Mar 01 17:32:01 1996 | @ 5 hours | Fri Mar 01 22:32:01 1996 | Fri Mar 01 12:32:01 1996
+ Mon Dec 30 17:32:01 1996 | @ 1 min | Mon Dec 30 17:33:01 1996 | Mon Dec 30 17:31:01 1996
+ Mon Dec 30 17:32:01 1996 | @ 5 hours | Mon Dec 30 22:32:01 1996 | Mon Dec 30 12:32:01 1996
+ Tue Dec 31 17:32:01 1996 | @ 1 min | Tue Dec 31 17:33:01 1996 | Tue Dec 31 17:31:01 1996
+ Tue Dec 31 17:32:01 1996 | @ 5 hours | Tue Dec 31 22:32:01 1996 | Tue Dec 31 12:32:01 1996
+ Wed Jan 01 17:32:01 1997 | @ 1 min | Wed Jan 01 17:33:01 1997 | Wed Jan 01 17:31:01 1997
+ Wed Jan 01 17:32:01 1997 | @ 5 hours | Wed Jan 01 22:32:01 1997 | Wed Jan 01 12:32:01 1997
+ Thu Jan 02 00:00:00 1997 | @ 1 min | Thu Jan 02 00:01:00 1997 | Wed Jan 01 23:59:00 1997
+ Thu Jan 02 00:00:00 1997 | @ 5 hours | Thu Jan 02 05:00:00 1997 | Wed Jan 01 19:00:00 1997
+ Thu Jan 02 03:04:05 1997 | @ 1 min | Thu Jan 02 03:05:05 1997 | Thu Jan 02 03:03:05 1997
+ Thu Jan 02 03:04:05 1997 | @ 5 hours | Thu Jan 02 08:04:05 1997 | Wed Jan 01 22:04:05 1997
+ Mon Feb 10 17:32:00 1997 | @ 1 min | Mon Feb 10 17:33:00 1997 | Mon Feb 10 17:31:00 1997
+ Mon Feb 10 17:32:00 1997 | @ 5 hours | Mon Feb 10 22:32:00 1997 | Mon Feb 10 12:32:00 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 1 min | Mon Feb 10 17:33:01 1997 | Mon Feb 10 17:31:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01 1997 | @ 5 hours | Mon Feb 10 22:32:01 1997 | Mon Feb 10 12:32:01 1997
+ Mon Feb 10 17:32:01.40 1997 | @ 1 min | Mon Feb 10 17:33:01.40 1997 | Mon Feb 10 17:31:01.40 1997
+ Mon Feb 10 17:32:01.40 1997 | @ 5 hours | Mon Feb 10 22:32:01.40 1997 | Mon Feb 10 12:32:01.40 1997
+ Mon Feb 10 17:32:01.50 1997 | @ 1 min | Mon Feb 10 17:33:01.50 1997 | Mon Feb 10 17:31:01.50 1997
+ Mon Feb 10 17:32:01.50 1997 | @ 5 hours | Mon Feb 10 22:32:01.50 1997 | Mon Feb 10 12:32:01.50 1997
+ Mon Feb 10 17:32:01.60 1997 | @ 1 min | Mon Feb 10 17:33:01.60 1997 | Mon Feb 10 17:31:01.60 1997
+ Mon Feb 10 17:32:01.60 1997 | @ 5 hours | Mon Feb 10 22:32:01.60 1997 | Mon Feb 10 12:32:01.60 1997
+ Mon Feb 10 17:32:02 1997 | @ 1 min | Mon Feb 10 17:33:02 1997 | Mon Feb 10 17:31:02 1997
+ Mon Feb 10 17:32:02 1997 | @ 5 hours | Mon Feb 10 22:32:02 1997 | Mon Feb 10 12:32:02 1997
+ Tue Feb 11 17:32:01 1997 | @ 1 min | Tue Feb 11 17:33:01 1997 | Tue Feb 11 17:31:01 1997
+ Tue Feb 11 17:32:01 1997 | @ 5 hours | Tue Feb 11 22:32:01 1997 | Tue Feb 11 12:32:01 1997
+ Wed Feb 12 17:32:01 1997 | @ 1 min | Wed Feb 12 17:33:01 1997 | Wed Feb 12 17:31:01 1997
+ Wed Feb 12 17:32:01 1997 | @ 5 hours | Wed Feb 12 22:32:01 1997 | Wed Feb 12 12:32:01 1997
+ Thu Feb 13 17:32:01 1997 | @ 1 min | Thu Feb 13 17:33:01 1997 | Thu Feb 13 17:31:01 1997
+ Thu Feb 13 17:32:01 1997 | @ 5 hours | Thu Feb 13 22:32:01 1997 | Thu Feb 13 12:32:01 1997
+ Fri Feb 14 17:32:01 1997 | @ 1 min | Fri Feb 14 17:33:01 1997 | Fri Feb 14 17:31:01 1997
+ Fri Feb 14 17:32:01 1997 | @ 5 hours | Fri Feb 14 22:32:01 1997 | Fri Feb 14 12:32:01 1997
+ Sat Feb 15 17:32:01 1997 | @ 1 min | Sat Feb 15 17:33:01 1997 | Sat Feb 15 17:31:01 1997
+ Sat Feb 15 17:32:01 1997 | @ 5 hours | Sat Feb 15 22:32:01 1997 | Sat Feb 15 12:32:01 1997
+ Sun Feb 16 17:32:01 1997 | @ 1 min | Sun Feb 16 17:33:01 1997 | Sun Feb 16 17:31:01 1997
+ Sun Feb 16 17:32:01 1997 | @ 1 min | Sun Feb 16 17:33:01 1997 | Sun Feb 16 17:31:01 1997
+ Sun Feb 16 17:32:01 1997 | @ 5 hours | Sun Feb 16 22:32:01 1997 | Sun Feb 16 12:32:01 1997
+ Sun Feb 16 17:32:01 1997 | @ 5 hours | Sun Feb 16 22:32:01 1997 | Sun Feb 16 12:32:01 1997
+ Fri Feb 28 17:32:01 1997 | @ 1 min | Fri Feb 28 17:33:01 1997 | Fri Feb 28 17:31:01 1997
+ Fri Feb 28 17:32:01 1997 | @ 5 hours | Fri Feb 28 22:32:01 1997 | Fri Feb 28 12:32:01 1997
+ Sat Mar 01 17:32:01 1997 | @ 1 min | Sat Mar 01 17:33:01 1997 | Sat Mar 01 17:31:01 1997
+ Sat Mar 01 17:32:01 1997 | @ 5 hours | Sat Mar 01 22:32:01 1997 | Sat Mar 01 12:32:01 1997
+ Tue Jun 10 17:32:01 1997 | @ 1 min | Tue Jun 10 17:33:01 1997 | Tue Jun 10 17:31:01 1997
+ Tue Jun 10 17:32:01 1997 | @ 5 hours | Tue Jun 10 22:32:01 1997 | Tue Jun 10 12:32:01 1997
+ Tue Jun 10 18:32:01 1997 | @ 1 min | Tue Jun 10 18:33:01 1997 | Tue Jun 10 18:31:01 1997
+ Tue Jun 10 18:32:01 1997 | @ 5 hours | Tue Jun 10 23:32:01 1997 | Tue Jun 10 13:32:01 1997
+ Tue Dec 30 17:32:01 1997 | @ 1 min | Tue Dec 30 17:33:01 1997 | Tue Dec 30 17:31:01 1997
+ Tue Dec 30 17:32:01 1997 | @ 5 hours | Tue Dec 30 22:32:01 1997 | Tue Dec 30 12:32:01 1997
+ Wed Dec 31 17:32:01 1997 | @ 1 min | Wed Dec 31 17:33:01 1997 | Wed Dec 31 17:31:01 1997
+ Wed Dec 31 17:32:01 1997 | @ 5 hours | Wed Dec 31 22:32:01 1997 | Wed Dec 31 12:32:01 1997
+ Fri Dec 31 17:32:01 1999 | @ 1 min | Fri Dec 31 17:33:01 1999 | Fri Dec 31 17:31:01 1999
+ Fri Dec 31 17:32:01 1999 | @ 5 hours | Fri Dec 31 22:32:01 1999 | Fri Dec 31 12:32:01 1999
+ Sat Jan 01 17:32:01 2000 | @ 1 min | Sat Jan 01 17:33:01 2000 | Sat Jan 01 17:31:01 2000
+ Sat Jan 01 17:32:01 2000 | @ 5 hours | Sat Jan 01 22:32:01 2000 | Sat Jan 01 12:32:01 2000
+ Wed Mar 15 02:14:05 2000 | @ 1 min | Wed Mar 15 02:15:05 2000 | Wed Mar 15 02:13:05 2000
+ Wed Mar 15 02:14:05 2000 | @ 5 hours | Wed Mar 15 07:14:05 2000 | Tue Mar 14 21:14:05 2000
+ Wed Mar 15 03:14:04 2000 | @ 1 min | Wed Mar 15 03:15:04 2000 | Wed Mar 15 03:13:04 2000
+ Wed Mar 15 03:14:04 2000 | @ 5 hours | Wed Mar 15 08:14:04 2000 | Tue Mar 14 22:14:04 2000
+ Wed Mar 15 08:14:01 2000 | @ 1 min | Wed Mar 15 08:15:01 2000 | Wed Mar 15 08:13:01 2000
+ Wed Mar 15 08:14:01 2000 | @ 5 hours | Wed Mar 15 13:14:01 2000 | Wed Mar 15 03:14:01 2000
+ Wed Mar 15 12:14:03 2000 | @ 1 min | Wed Mar 15 12:15:03 2000 | Wed Mar 15 12:13:03 2000
+ Wed Mar 15 12:14:03 2000 | @ 5 hours | Wed Mar 15 17:14:03 2000 | Wed Mar 15 07:14:03 2000
+ Wed Mar 15 13:14:02 2000 | @ 1 min | Wed Mar 15 13:15:02 2000 | Wed Mar 15 13:13:02 2000
+ Wed Mar 15 13:14:02 2000 | @ 5 hours | Wed Mar 15 18:14:02 2000 | Wed Mar 15 08:14:02 2000
+ Sun Dec 31 17:32:01 2000 | @ 1 min | Sun Dec 31 17:33:01 2000 | Sun Dec 31 17:31:01 2000
+ Sun Dec 31 17:32:01 2000 | @ 5 hours | Sun Dec 31 22:32:01 2000 | Sun Dec 31 12:32:01 2000
(104 rows)
-SELECT t.f1 + i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
- 80
--------------
- 00:01:00
- 05:00:00
- 00:00:00
- 00:00:00
- 00:00:00
- 23:59:46
- 02:03:04
- 00:00:00
- 00:00:00
- 12:00:00
- 01:01:00
- 06:00:00
- 01:00:00
- 01:00:00
- 01:00:00
- 00:59:46
- 03:03:04
- 01:00:00
- 01:00:00
- 13:00:00
- 02:04:00
- 07:03:00
- 02:03:00
- 02:03:00
- 02:03:00
- 02:02:46
- 04:06:04
- 02:03:00
- 02:03:00
- 14:03:00
- 12:00:00
- 16:59:00
- 11:59:00
- 11:59:00
- 11:59:00
- 11:58:46
- 14:02:04
- 11:59:00
- 11:59:00
- 23:59:00
- 12:01:00
- 17:00:00
- 12:00:00
- 12:00:00
- 12:00:00
- 11:59:46
- 14:03:04
- 12:00:00
- 12:00:00
- 00:00:00
- 12:02:00
- 17:01:00
- 12:01:00
- 12:01:00
- 12:01:00
- 12:00:46
- 14:04:04
- 12:01:00
- 12:01:00
- 00:01:00
- 00:00:00
- 04:59:00
- 23:59:00
- 23:59:00
- 23:59:00
- 23:58:46
- 02:02:04
- 23:59:00
- 23:59:00
- 11:59:00
- 00:00:59.99
- 04:59:59.99
- 23:59:59.99
- 23:59:59.99
- 23:59:59.99
- 23:59:45.99
- 02:03:03.99
- 23:59:59.99
- 23:59:59.99
- 11:59:59.99
- 15:37:39
- 20:36:39
- 15:36:39
- 15:36:39
- 15:36:39
- 15:36:25
- 17:39:43
- 15:36:39
- 15:36:39
- 03:36:39
- 15:37:39
- 20:36:39
- 15:36:39
- 15:36:39
- 15:36:39
- 15:36:25
- 17:39:43
- 15:36:39
- 15:36:39
- 03:36:39
+SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"
+ FROM TIME_TBL t, INTERVAL_TBL i
+ ORDER BY 1,2;
+ t | i | add | subtract
+-------------+-------------------------------+-------------+-------------
+ 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14
+ 00:00:00 | @ 1 min | 00:01:00 | 23:59:00
+ 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00
+ 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56
+ 00:00:00 | @ 10 days | 00:00:00 | 00:00:00
+ 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00
+ 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00
+ 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00
+ 00:00:00 | @ 6 years | 00:00:00 | 00:00:00
+ 00:00:00 | @ 34 years | 00:00:00 | 00:00:00
+ 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14
+ 01:00:00 | @ 1 min | 01:01:00 | 00:59:00
+ 01:00:00 | @ 5 hours | 06:00:00 | 20:00:00
+ 01:00:00 | @ 1 day 2 hours 3 mins 4 secs | 03:03:04 | 22:56:56
+ 01:00:00 | @ 10 days | 01:00:00 | 01:00:00
+ 01:00:00 | @ 3 mons | 01:00:00 | 01:00:00
+ 01:00:00 | @ 5 mons | 01:00:00 | 01:00:00
+ 01:00:00 | @ 5 mons 12 hours | 13:00:00 | 13:00:00
+ 01:00:00 | @ 6 years | 01:00:00 | 01:00:00
+ 01:00:00 | @ 34 years | 01:00:00 | 01:00:00
+ 02:03:00 | @ 14 secs ago | 02:02:46 | 02:03:14
+ 02:03:00 | @ 1 min | 02:04:00 | 02:02:00
+ 02:03:00 | @ 5 hours | 07:03:00 | 21:03:00
+ 02:03:00 | @ 1 day 2 hours 3 mins 4 secs | 04:06:04 | 23:59:56
+ 02:03:00 | @ 10 days | 02:03:00 | 02:03:00
+ 02:03:00 | @ 3 mons | 02:03:00 | 02:03:00
+ 02:03:00 | @ 5 mons | 02:03:00 | 02:03:00
+ 02:03:00 | @ 5 mons 12 hours | 14:03:00 | 14:03:00
+ 02:03:00 | @ 6 years | 02:03:00 | 02:03:00
+ 02:03:00 | @ 34 years | 02:03:00 | 02:03:00
+ 11:59:00 | @ 14 secs ago | 11:58:46 | 11:59:14
+ 11:59:00 | @ 1 min | 12:00:00 | 11:58:00
+ 11:59:00 | @ 5 hours | 16:59:00 | 06:59:00
+ 11:59:00 | @ 1 day 2 hours 3 mins 4 secs | 14:02:04 | 09:55:56
+ 11:59:00 | @ 10 days | 11:59:00 | 11:59:00
+ 11:59:00 | @ 3 mons | 11:59:00 | 11:59:00
+ 11:59:00 | @ 5 mons | 11:59:00 | 11:59:00
+ 11:59:00 | @ 5 mons 12 hours | 23:59:00 | 23:59:00
+ 11:59:00 | @ 6 years | 11:59:00 | 11:59:00
+ 11:59:00 | @ 34 years | 11:59:00 | 11:59:00
+ 12:00:00 | @ 14 secs ago | 11:59:46 | 12:00:14
+ 12:00:00 | @ 1 min | 12:01:00 | 11:59:00
+ 12:00:00 | @ 5 hours | 17:00:00 | 07:00:00
+ 12:00:00 | @ 1 day 2 hours 3 mins 4 secs | 14:03:04 | 09:56:56
+ 12:00:00 | @ 10 days | 12:00:00 | 12:00:00
+ 12:00:00 | @ 3 mons | 12:00:00 | 12:00:00
+ 12:00:00 | @ 5 mons | 12:00:00 | 12:00:00
+ 12:00:00 | @ 5 mons 12 hours | 00:00:00 | 00:00:00
+ 12:00:00 | @ 6 years | 12:00:00 | 12:00:00
+ 12:00:00 | @ 34 years | 12:00:00 | 12:00:00
+ 12:01:00 | @ 14 secs ago | 12:00:46 | 12:01:14
+ 12:01:00 | @ 1 min | 12:02:00 | 12:00:00
+ 12:01:00 | @ 5 hours | 17:01:00 | 07:01:00
+ 12:01:00 | @ 1 day 2 hours 3 mins 4 secs | 14:04:04 | 09:57:56
+ 12:01:00 | @ 10 days | 12:01:00 | 12:01:00
+ 12:01:00 | @ 3 mons | 12:01:00 | 12:01:00
+ 12:01:00 | @ 5 mons | 12:01:00 | 12:01:00
+ 12:01:00 | @ 5 mons 12 hours | 00:01:00 | 00:01:00
+ 12:01:00 | @ 6 years | 12:01:00 | 12:01:00
+ 12:01:00 | @ 34 years | 12:01:00 | 12:01:00
+ 15:36:39 | @ 14 secs ago | 15:36:25 | 15:36:53
+ 15:36:39 | @ 14 secs ago | 15:36:25 | 15:36:53
+ 15:36:39 | @ 1 min | 15:37:39 | 15:35:39
+ 15:36:39 | @ 1 min | 15:37:39 | 15:35:39
+ 15:36:39 | @ 5 hours | 20:36:39 | 10:36:39
+ 15:36:39 | @ 5 hours | 20:36:39 | 10:36:39
+ 15:36:39 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43 | 13:33:35
+ 15:36:39 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43 | 13:33:35
+ 15:36:39 | @ 10 days | 15:36:39 | 15:36:39
+ 15:36:39 | @ 10 days | 15:36:39 | 15:36:39
+ 15:36:39 | @ 3 mons | 15:36:39 | 15:36:39
+ 15:36:39 | @ 3 mons | 15:36:39 | 15:36:39
+ 15:36:39 | @ 5 mons | 15:36:39 | 15:36:39
+ 15:36:39 | @ 5 mons | 15:36:39 | 15:36:39
+ 15:36:39 | @ 5 mons 12 hours | 03:36:39 | 03:36:39
+ 15:36:39 | @ 5 mons 12 hours | 03:36:39 | 03:36:39
+ 15:36:39 | @ 6 years | 15:36:39 | 15:36:39
+ 15:36:39 | @ 6 years | 15:36:39 | 15:36:39
+ 15:36:39 | @ 34 years | 15:36:39 | 15:36:39
+ 15:36:39 | @ 34 years | 15:36:39 | 15:36:39
+ 23:59:00 | @ 14 secs ago | 23:58:46 | 23:59:14
+ 23:59:00 | @ 1 min | 00:00:00 | 23:58:00
+ 23:59:00 | @ 5 hours | 04:59:00 | 18:59:00
+ 23:59:00 | @ 1 day 2 hours 3 mins 4 secs | 02:02:04 | 21:55:56
+ 23:59:00 | @ 10 days | 23:59:00 | 23:59:00
+ 23:59:00 | @ 3 mons | 23:59:00 | 23:59:00
+ 23:59:00 | @ 5 mons | 23:59:00 | 23:59:00
+ 23:59:00 | @ 5 mons 12 hours | 11:59:00 | 11:59:00
+ 23:59:00 | @ 6 years | 23:59:00 | 23:59:00
+ 23:59:00 | @ 34 years | 23:59:00 | 23:59:00
+ 23:59:59.99 | @ 14 secs ago | 23:59:45.99 | 00:00:13.99
+ 23:59:59.99 | @ 1 min | 00:00:59.99 | 23:58:59.99
+ 23:59:59.99 | @ 5 hours | 04:59:59.99 | 18:59:59.99
+ 23:59:59.99 | @ 1 day 2 hours 3 mins 4 secs | 02:03:03.99 | 21:56:55.99
+ 23:59:59.99 | @ 10 days | 23:59:59.99 | 23:59:59.99
+ 23:59:59.99 | @ 3 mons | 23:59:59.99 | 23:59:59.99
+ 23:59:59.99 | @ 5 mons | 23:59:59.99 | 23:59:59.99
+ 23:59:59.99 | @ 5 mons 12 hours | 11:59:59.99 | 11:59:59.99
+ 23:59:59.99 | @ 6 years | 23:59:59.99 | 23:59:59.99
+ 23:59:59.99 | @ 34 years | 23:59:59.99 | 23:59:59.99
(100 rows)
-SELECT t.f1 - i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
- 80
--------------
- 23:59:00
- 19:00:00
- 00:00:00
- 00:00:00
- 00:00:00
- 00:00:14
- 21:56:56
- 00:00:00
- 00:00:00
- 12:00:00
- 00:59:00
- 20:00:00
- 01:00:00
- 01:00:00
- 01:00:00
- 01:00:14
- 22:56:56
- 01:00:00
- 01:00:00
- 13:00:00
- 02:02:00
- 21:03:00
- 02:03:00
- 02:03:00
- 02:03:00
- 02:03:14
- 23:59:56
- 02:03:00
- 02:03:00
- 14:03:00
- 11:58:00
- 06:59:00
- 11:59:00
- 11:59:00
- 11:59:00
- 11:59:14
- 09:55:56
- 11:59:00
- 11:59:00
- 23:59:00
- 11:59:00
- 07:00:00
- 12:00:00
- 12:00:00
- 12:00:00
- 12:00:14
- 09:56:56
- 12:00:00
- 12:00:00
- 00:00:00
- 12:00:00
- 07:01:00
- 12:01:00
- 12:01:00
- 12:01:00
- 12:01:14
- 09:57:56
- 12:01:00
- 12:01:00
- 00:01:00
- 23:58:00
- 18:59:00
- 23:59:00
- 23:59:00
- 23:59:00
- 23:59:14
- 21:55:56
- 23:59:00
- 23:59:00
- 11:59:00
- 23:58:59.99
- 18:59:59.99
- 23:59:59.99
- 23:59:59.99
- 23:59:59.99
- 00:00:13.99
- 21:56:55.99
- 23:59:59.99
- 23:59:59.99
- 11:59:59.99
- 15:35:39
- 10:36:39
- 15:36:39
- 15:36:39
- 15:36:39
- 15:36:53
- 13:33:35
- 15:36:39
- 15:36:39
- 03:36:39
- 15:35:39
- 10:36:39
- 15:36:39
- 15:36:39
- 15:36:39
- 15:36:53
- 13:33:35
- 15:36:39
- 15:36:39
- 03:36:39
-(100 rows)
-
-SELECT t.f1 + i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
- 100
-----------------
- 00:02:00-07
- 05:01:00-07
- 00:01:00-07
- 00:01:00-07
- 00:01:00-07
- 00:00:46-07
- 02:04:04-07
- 00:01:00-07
- 00:01:00-07
- 12:01:00-07
- 01:01:00-07
- 06:00:00-07
- 01:00:00-07
- 01:00:00-07
- 01:00:00-07
- 00:59:46-07
- 03:03:04-07
- 01:00:00-07
- 01:00:00-07
- 13:00:00-07
- 02:04:00-07
- 07:03:00-07
- 02:03:00-07
- 02:03:00-07
- 02:03:00-07
- 02:02:46-07
- 04:06:04-07
- 02:03:00-07
- 02:03:00-07
- 14:03:00-07
- 07:08:00-08
- 12:07:00-08
- 07:07:00-08
- 07:07:00-08
- 07:07:00-08
- 07:06:46-08
- 09:10:04-08
- 07:07:00-08
- 07:07:00-08
- 19:07:00-08
- 08:09:00-04
- 13:08:00-04
- 08:08:00-04
- 08:08:00-04
- 08:08:00-04
- 08:07:46-04
- 10:11:04-04
- 08:08:00-04
- 08:08:00-04
- 20:08:00-04
- 12:00:00-07
- 16:59:00-07
- 11:59:00-07
- 11:59:00-07
- 11:59:00-07
- 11:58:46-07
- 14:02:04-07
- 11:59:00-07
- 11:59:00-07
- 23:59:00-07
- 12:01:00-07
- 17:00:00-07
- 12:00:00-07
- 12:00:00-07
- 12:00:00-07
- 11:59:46-07
- 14:03:04-07
- 12:00:00-07
- 12:00:00-07
- 00:00:00-07
- 12:02:00-07
- 17:01:00-07
- 12:01:00-07
- 12:01:00-07
- 12:01:00-07
- 12:00:46-07
- 14:04:04-07
- 12:01:00-07
- 12:01:00-07
- 00:01:00-07
- 00:00:00-07
- 04:59:00-07
- 23:59:00-07
- 23:59:00-07
- 23:59:00-07
- 23:58:46-07
- 02:02:04-07
- 23:59:00-07
- 23:59:00-07
- 11:59:00-07
- 00:00:59.99-07
- 04:59:59.99-07
- 23:59:59.99-07
- 23:59:59.99-07
- 23:59:59.99-07
- 23:59:45.99-07
- 02:03:03.99-07
- 23:59:59.99-07
- 23:59:59.99-07
- 11:59:59.99-07
- 15:37:39-05
- 20:36:39-05
- 15:36:39-05
- 15:36:39-05
- 15:36:39-05
- 15:36:25-05
- 17:39:43-05
- 15:36:39-05
- 15:36:39-05
- 03:36:39-05
- 15:37:39-04
- 20:36:39-04
- 15:36:39-04
- 15:36:39-04
- 15:36:39-04
- 15:36:25-04
- 17:39:43-04
- 15:36:39-04
- 15:36:39-04
- 03:36:39-04
-(120 rows)
-
-SELECT t.f1 - i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
- 100
-----------------
- 00:00:00-07
- 19:01:00-07
- 00:01:00-07
- 00:01:00-07
- 00:01:00-07
- 00:01:14-07
- 21:57:56-07
- 00:01:00-07
- 00:01:00-07
- 12:01:00-07
- 00:59:00-07
- 20:00:00-07
- 01:00:00-07
- 01:00:00-07
- 01:00:00-07
- 01:00:14-07
- 22:56:56-07
- 01:00:00-07
- 01:00:00-07
- 13:00:00-07
- 02:02:00-07
- 21:03:00-07
- 02:03:00-07
- 02:03:00-07
- 02:03:00-07
- 02:03:14-07
- 23:59:56-07
- 02:03:00-07
- 02:03:00-07
- 14:03:00-07
- 07:06:00-08
- 02:07:00-08
- 07:07:00-08
- 07:07:00-08
- 07:07:00-08
- 07:07:14-08
- 05:03:56-08
- 07:07:00-08
- 07:07:00-08
- 19:07:00-08
- 08:07:00-04
- 03:08:00-04
- 08:08:00-04
- 08:08:00-04
- 08:08:00-04
- 08:08:14-04
- 06:04:56-04
- 08:08:00-04
- 08:08:00-04
- 20:08:00-04
- 11:58:00-07
- 06:59:00-07
- 11:59:00-07
- 11:59:00-07
- 11:59:00-07
- 11:59:14-07
- 09:55:56-07
- 11:59:00-07
- 11:59:00-07
- 23:59:00-07
- 11:59:00-07
- 07:00:00-07
- 12:00:00-07
- 12:00:00-07
- 12:00:00-07
- 12:00:14-07
- 09:56:56-07
- 12:00:00-07
- 12:00:00-07
- 00:00:00-07
- 12:00:00-07
- 07:01:00-07
- 12:01:00-07
- 12:01:00-07
- 12:01:00-07
- 12:01:14-07
- 09:57:56-07
- 12:01:00-07
- 12:01:00-07
- 00:01:00-07
- 23:58:00-07
- 18:59:00-07
- 23:59:00-07
- 23:59:00-07
- 23:59:00-07
- 23:59:14-07
- 21:55:56-07
- 23:59:00-07
- 23:59:00-07
- 11:59:00-07
- 23:58:59.99-07
- 18:59:59.99-07
- 23:59:59.99-07
- 23:59:59.99-07
- 23:59:59.99-07
- 00:00:13.99-07
- 21:56:55.99-07
- 23:59:59.99-07
- 23:59:59.99-07
- 11:59:59.99-07
- 15:35:39-05
- 10:36:39-05
- 15:36:39-05
- 15:36:39-05
- 15:36:39-05
- 15:36:53-05
- 13:33:35-05
- 15:36:39-05
- 15:36:39-05
- 03:36:39-05
- 15:35:39-04
- 10:36:39-04
- 15:36:39-04
- 15:36:39-04
- 15:36:39-04
- 15:36:53-04
- 13:33:35-04
- 15:36:39-04
- 15:36:39-04
- 03:36:39-04
+SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"
+ FROM TIMETZ_TBL t, INTERVAL_TBL i
+ ORDER BY 1,2;
+ t | i | add | subtract
+----------------+-------------------------------+----------------+----------------
+ 00:01:00-07 | @ 14 secs ago | 00:00:46-07 | 00:01:14-07
+ 00:01:00-07 | @ 1 min | 00:02:00-07 | 00:00:00-07
+ 00:01:00-07 | @ 5 hours | 05:01:00-07 | 19:01:00-07
+ 00:01:00-07 | @ 1 day 2 hours 3 mins 4 secs | 02:04:04-07 | 21:57:56-07
+ 00:01:00-07 | @ 10 days | 00:01:00-07 | 00:01:00-07
+ 00:01:00-07 | @ 3 mons | 00:01:00-07 | 00:01:00-07
+ 00:01:00-07 | @ 5 mons | 00:01:00-07 | 00:01:00-07
+ 00:01:00-07 | @ 5 mons 12 hours | 12:01:00-07 | 12:01:00-07
+ 00:01:00-07 | @ 6 years | 00:01:00-07 | 00:01:00-07
+ 00:01:00-07 | @ 34 years | 00:01:00-07 | 00:01:00-07
+ 01:00:00-07 | @ 14 secs ago | 00:59:46-07 | 01:00:14-07
+ 01:00:00-07 | @ 1 min | 01:01:00-07 | 00:59:00-07
+ 01:00:00-07 | @ 5 hours | 06:00:00-07 | 20:00:00-07
+ 01:00:00-07 | @ 1 day 2 hours 3 mins 4 secs | 03:03:04-07 | 22:56:56-07
+ 01:00:00-07 | @ 10 days | 01:00:00-07 | 01:00:00-07
+ 01:00:00-07 | @ 3 mons | 01:00:00-07 | 01:00:00-07
+ 01:00:00-07 | @ 5 mons | 01:00:00-07 | 01:00:00-07
+ 01:00:00-07 | @ 5 mons 12 hours | 13:00:00-07 | 13:00:00-07
+ 01:00:00-07 | @ 6 years | 01:00:00-07 | 01:00:00-07
+ 01:00:00-07 | @ 34 years | 01:00:00-07 | 01:00:00-07
+ 02:03:00-07 | @ 14 secs ago | 02:02:46-07 | 02:03:14-07
+ 02:03:00-07 | @ 1 min | 02:04:00-07 | 02:02:00-07
+ 02:03:00-07 | @ 5 hours | 07:03:00-07 | 21:03:00-07
+ 02:03:00-07 | @ 1 day 2 hours 3 mins 4 secs | 04:06:04-07 | 23:59:56-07
+ 02:03:00-07 | @ 10 days | 02:03:00-07 | 02:03:00-07
+ 02:03:00-07 | @ 3 mons | 02:03:00-07 | 02:03:00-07
+ 02:03:00-07 | @ 5 mons | 02:03:00-07 | 02:03:00-07
+ 02:03:00-07 | @ 5 mons 12 hours | 14:03:00-07 | 14:03:00-07
+ 02:03:00-07 | @ 6 years | 02:03:00-07 | 02:03:00-07
+ 02:03:00-07 | @ 34 years | 02:03:00-07 | 02:03:00-07
+ 08:08:00-04 | @ 14 secs ago | 08:07:46-04 | 08:08:14-04
+ 08:08:00-04 | @ 1 min | 08:09:00-04 | 08:07:00-04
+ 08:08:00-04 | @ 5 hours | 13:08:00-04 | 03:08:00-04
+ 08:08:00-04 | @ 1 day 2 hours 3 mins 4 secs | 10:11:04-04 | 06:04:56-04
+ 08:08:00-04 | @ 10 days | 08:08:00-04 | 08:08:00-04
+ 08:08:00-04 | @ 3 mons | 08:08:00-04 | 08:08:00-04
+ 08:08:00-04 | @ 5 mons | 08:08:00-04 | 08:08:00-04
+ 08:08:00-04 | @ 5 mons 12 hours | 20:08:00-04 | 20:08:00-04
+ 08:08:00-04 | @ 6 years | 08:08:00-04 | 08:08:00-04
+ 08:08:00-04 | @ 34 years | 08:08:00-04 | 08:08:00-04
+ 07:07:00-08 | @ 14 secs ago | 07:06:46-08 | 07:07:14-08
+ 07:07:00-08 | @ 1 min | 07:08:00-08 | 07:06:00-08
+ 07:07:00-08 | @ 5 hours | 12:07:00-08 | 02:07:00-08
+ 07:07:00-08 | @ 1 day 2 hours 3 mins 4 secs | 09:10:04-08 | 05:03:56-08
+ 07:07:00-08 | @ 10 days | 07:07:00-08 | 07:07:00-08
+ 07:07:00-08 | @ 3 mons | 07:07:00-08 | 07:07:00-08
+ 07:07:00-08 | @ 5 mons | 07:07:00-08 | 07:07:00-08
+ 07:07:00-08 | @ 5 mons 12 hours | 19:07:00-08 | 19:07:00-08
+ 07:07:00-08 | @ 6 years | 07:07:00-08 | 07:07:00-08
+ 07:07:00-08 | @ 34 years | 07:07:00-08 | 07:07:00-08
+ 11:59:00-07 | @ 14 secs ago | 11:58:46-07 | 11:59:14-07
+ 11:59:00-07 | @ 1 min | 12:00:00-07 | 11:58:00-07
+ 11:59:00-07 | @ 5 hours | 16:59:00-07 | 06:59:00-07
+ 11:59:00-07 | @ 1 day 2 hours 3 mins 4 secs | 14:02:04-07 | 09:55:56-07
+ 11:59:00-07 | @ 10 days | 11:59:00-07 | 11:59:00-07
+ 11:59:00-07 | @ 3 mons | 11:59:00-07 | 11:59:00-07
+ 11:59:00-07 | @ 5 mons | 11:59:00-07 | 11:59:00-07
+ 11:59:00-07 | @ 5 mons 12 hours | 23:59:00-07 | 23:59:00-07
+ 11:59:00-07 | @ 6 years | 11:59:00-07 | 11:59:00-07
+ 11:59:00-07 | @ 34 years | 11:59:00-07 | 11:59:00-07
+ 12:00:00-07 | @ 14 secs ago | 11:59:46-07 | 12:00:14-07
+ 12:00:00-07 | @ 1 min | 12:01:00-07 | 11:59:00-07
+ 12:00:00-07 | @ 5 hours | 17:00:00-07 | 07:00:00-07
+ 12:00:00-07 | @ 1 day 2 hours 3 mins 4 secs | 14:03:04-07 | 09:56:56-07
+ 12:00:00-07 | @ 10 days | 12:00:00-07 | 12:00:00-07
+ 12:00:00-07 | @ 3 mons | 12:00:00-07 | 12:00:00-07
+ 12:00:00-07 | @ 5 mons | 12:00:00-07 | 12:00:00-07
+ 12:00:00-07 | @ 5 mons 12 hours | 00:00:00-07 | 00:00:00-07
+ 12:00:00-07 | @ 6 years | 12:00:00-07 | 12:00:00-07
+ 12:00:00-07 | @ 34 years | 12:00:00-07 | 12:00:00-07
+ 12:01:00-07 | @ 14 secs ago | 12:00:46-07 | 12:01:14-07
+ 12:01:00-07 | @ 1 min | 12:02:00-07 | 12:00:00-07
+ 12:01:00-07 | @ 5 hours | 17:01:00-07 | 07:01:00-07
+ 12:01:00-07 | @ 1 day 2 hours 3 mins 4 secs | 14:04:04-07 | 09:57:56-07
+ 12:01:00-07 | @ 10 days | 12:01:00-07 | 12:01:00-07
+ 12:01:00-07 | @ 3 mons | 12:01:00-07 | 12:01:00-07
+ 12:01:00-07 | @ 5 mons | 12:01:00-07 | 12:01:00-07
+ 12:01:00-07 | @ 5 mons 12 hours | 00:01:00-07 | 00:01:00-07
+ 12:01:00-07 | @ 6 years | 12:01:00-07 | 12:01:00-07
+ 12:01:00-07 | @ 34 years | 12:01:00-07 | 12:01:00-07
+ 15:36:39-04 | @ 14 secs ago | 15:36:25-04 | 15:36:53-04
+ 15:36:39-04 | @ 1 min | 15:37:39-04 | 15:35:39-04
+ 15:36:39-04 | @ 5 hours | 20:36:39-04 | 10:36:39-04
+ 15:36:39-04 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43-04 | 13:33:35-04
+ 15:36:39-04 | @ 10 days | 15:36:39-04 | 15:36:39-04
+ 15:36:39-04 | @ 3 mons | 15:36:39-04 | 15:36:39-04
+ 15:36:39-04 | @ 5 mons | 15:36:39-04 | 15:36:39-04
+ 15:36:39-04 | @ 5 mons 12 hours | 03:36:39-04 | 03:36:39-04
+ 15:36:39-04 | @ 6 years | 15:36:39-04 | 15:36:39-04
+ 15:36:39-04 | @ 34 years | 15:36:39-04 | 15:36:39-04
+ 15:36:39-05 | @ 14 secs ago | 15:36:25-05 | 15:36:53-05
+ 15:36:39-05 | @ 1 min | 15:37:39-05 | 15:35:39-05
+ 15:36:39-05 | @ 5 hours | 20:36:39-05 | 10:36:39-05
+ 15:36:39-05 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43-05 | 13:33:35-05
+ 15:36:39-05 | @ 10 days | 15:36:39-05 | 15:36:39-05
+ 15:36:39-05 | @ 3 mons | 15:36:39-05 | 15:36:39-05
+ 15:36:39-05 | @ 5 mons | 15:36:39-05 | 15:36:39-05
+ 15:36:39-05 | @ 5 mons 12 hours | 03:36:39-05 | 03:36:39-05
+ 15:36:39-05 | @ 6 years | 15:36:39-05 | 15:36:39-05
+ 15:36:39-05 | @ 34 years | 15:36:39-05 | 15:36:39-05
+ 23:59:00-07 | @ 14 secs ago | 23:58:46-07 | 23:59:14-07
+ 23:59:00-07 | @ 1 min | 00:00:00-07 | 23:58:00-07
+ 23:59:00-07 | @ 5 hours | 04:59:00-07 | 18:59:00-07
+ 23:59:00-07 | @ 1 day 2 hours 3 mins 4 secs | 02:02:04-07 | 21:55:56-07
+ 23:59:00-07 | @ 10 days | 23:59:00-07 | 23:59:00-07
+ 23:59:00-07 | @ 3 mons | 23:59:00-07 | 23:59:00-07
+ 23:59:00-07 | @ 5 mons | 23:59:00-07 | 23:59:00-07
+ 23:59:00-07 | @ 5 mons 12 hours | 11:59:00-07 | 11:59:00-07
+ 23:59:00-07 | @ 6 years | 23:59:00-07 | 23:59:00-07
+ 23:59:00-07 | @ 34 years | 23:59:00-07 | 23:59:00-07
+ 23:59:59.99-07 | @ 14 secs ago | 23:59:45.99-07 | 00:00:13.99-07
+ 23:59:59.99-07 | @ 1 min | 00:00:59.99-07 | 23:58:59.99-07
+ 23:59:59.99-07 | @ 5 hours | 04:59:59.99-07 | 18:59:59.99-07
+ 23:59:59.99-07 | @ 1 day 2 hours 3 mins 4 secs | 02:03:03.99-07 | 21:56:55.99-07
+ 23:59:59.99-07 | @ 10 days | 23:59:59.99-07 | 23:59:59.99-07
+ 23:59:59.99-07 | @ 3 mons | 23:59:59.99-07 | 23:59:59.99-07
+ 23:59:59.99-07 | @ 5 mons | 23:59:59.99-07 | 23:59:59.99-07
+ 23:59:59.99-07 | @ 5 mons 12 hours | 11:59:59.99-07 | 11:59:59.99-07
+ 23:59:59.99-07 | @ 6 years | 23:59:59.99-07 | 23:59:59.99-07
+ 23:59:59.99-07 | @ 34 years | 23:59:59.99-07 | 23:59:59.99-07
(120 rows)
-- SQL9x OVERLAPS operator
diff --git a/src/test/regress/sql/horology.sql b/src/test/regress/sql/horology.sql
index c6d78b20cf2..f6caffa7347 100644
--- a/src/test/regress/sql/horology.sql
+++ b/src/test/regress/sql/horology.sql
@@ -157,19 +157,19 @@ SELECT CAST(CAST(date 'today' + time with time zone '05:30'
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";
-SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
+SELECT t.d1 AS t, i.f1 AS i, t.d1 + i.f1 AS "add", t.d1 - i.f1 AS "subtract"
+ FROM TIMESTAMP_TBL t, INTERVAL_TBL i
WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
- AND i.f1 BETWEEN '00:00' AND '23:00';
+ AND i.f1 BETWEEN '00:00' AND '23:00'
+ ORDER BY 1,2;
-SELECT t.d1 - i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
- WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
- AND i.f1 BETWEEN '00:00' AND '23:00';
-
-SELECT t.f1 + i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
-SELECT t.f1 - i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
+SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"
+ FROM TIME_TBL t, INTERVAL_TBL i
+ ORDER BY 1,2;
-SELECT t.f1 + i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
-SELECT t.f1 - i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
+SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"
+ FROM TIMETZ_TBL t, INTERVAL_TBL i
+ ORDER BY 1,2;
-- SQL9x OVERLAPS operator
-- test with time zone