diff options
Diffstat (limited to 'src/test/regress/sql/horology.sql')
| -rw-r--r-- | src/test/regress/sql/horology.sql | 20 |
1 files changed, 10 insertions, 10 deletions
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 |