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