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;