1-- 2-- RELTIME 3-- 4 5CREATE TABLE RELTIME_TBL (f1 reltime); 6 7INSERT INTO RELTIME_TBL (f1) VALUES ('@ 1 minute'); 8 9INSERT INTO RELTIME_TBL (f1) VALUES ('@ 5 hour'); 10 11INSERT INTO RELTIME_TBL (f1) VALUES ('@ 10 day'); 12 13INSERT INTO RELTIME_TBL (f1) VALUES ('@ 34 year'); 14 15INSERT INTO RELTIME_TBL (f1) VALUES ('@ 3 months'); 16 17INSERT INTO RELTIME_TBL (f1) VALUES ('@ 14 seconds ago'); 18 19 20-- badly formatted reltimes 21INSERT INTO RELTIME_TBL (f1) VALUES ('badly formatted reltime'); 22 23INSERT INTO RELTIME_TBL (f1) VALUES ('@ 30 eons ago'); 24 25-- test reltime operators 26 27SELECT '' AS six, * FROM RELTIME_TBL; 28 29SELECT '' AS five, * FROM RELTIME_TBL 30 WHERE RELTIME_TBL.f1 <> reltime '@ 10 days'; 31 32SELECT '' AS three, * FROM RELTIME_TBL 33 WHERE RELTIME_TBL.f1 <= reltime '@ 5 hours'; 34 35SELECT '' AS three, * FROM RELTIME_TBL 36 WHERE RELTIME_TBL.f1 < reltime '@ 1 day'; 37 38SELECT '' AS one, * FROM RELTIME_TBL 39 WHERE RELTIME_TBL.f1 = reltime '@ 34 years'; 40 41SELECT '' AS two, * FROM RELTIME_TBL 42 WHERE RELTIME_TBL.f1 >= reltime '@ 1 month'; 43 44SELECT '' AS five, * FROM RELTIME_TBL 45 WHERE RELTIME_TBL.f1 > reltime '@ 3 seconds ago'; 46 47SELECT '' AS fifteen, r1.*, r2.* 48 FROM RELTIME_TBL r1, RELTIME_TBL r2 49 WHERE r1.f1 > r2.f1 50 ORDER BY r1.f1, r2.f1; 51