diff options
Diffstat (limited to 'src/test/regress/sql/reltime.sql')
| -rw-r--r-- | src/test/regress/sql/reltime.sql | 15 |
1 files changed, 7 insertions, 8 deletions
diff --git a/src/test/regress/sql/reltime.sql b/src/test/regress/sql/reltime.sql index 53295d3e66..a07b64e29d 100644 --- a/src/test/regress/sql/reltime.sql +++ b/src/test/regress/sql/reltime.sql @@ -24,28 +24,27 @@ INSERT INTO RELTIME_TBL (f1) VALUES ('@ 30 eons ago'); -- test reltime operators -SELECT '' AS six, RELTIME_TBL.*; +SELECT '' AS six, * FROM RELTIME_TBL; -SELECT '' AS five, RELTIME_TBL.* +SELECT '' AS five, * FROM RELTIME_TBL WHERE RELTIME_TBL.f1 <> reltime '@ 10 days'; -SELECT '' AS three, RELTIME_TBL.* +SELECT '' AS three, * FROM RELTIME_TBL WHERE RELTIME_TBL.f1 <= reltime '@ 5 hours'; -SELECT '' AS three, RELTIME_TBL.* +SELECT '' AS three, * FROM RELTIME_TBL WHERE RELTIME_TBL.f1 < reltime '@ 1 day'; -SELECT '' AS one, RELTIME_TBL.* +SELECT '' AS one, * FROM RELTIME_TBL WHERE RELTIME_TBL.f1 = reltime '@ 34 years'; -SELECT '' AS two, RELTIME_TBL.* +SELECT '' AS two, * FROM RELTIME_TBL WHERE RELTIME_TBL.f1 >= reltime '@ 1 month'; -SELECT '' AS five, RELTIME_TBL.* +SELECT '' AS five, * FROM RELTIME_TBL WHERE RELTIME_TBL.f1 > reltime '@ 3 seconds ago'; SELECT '' AS fifteen, r1.*, r2.* FROM RELTIME_TBL r1, RELTIME_TBL r2 WHERE r1.f1 > r2.f1 ORDER BY r1.f1, r2.f1; - |