2
CREATE TABLE timetmp (a time);
3
\copy timetmp from 'data/time.data'
5
SELECT count(*) FROM timetmp WHERE a < '10:57:11';
11
SELECT count(*) FROM timetmp WHERE a <= '10:57:11';
17
SELECT count(*) FROM timetmp WHERE a = '10:57:11';
23
SELECT count(*) FROM timetmp WHERE a >= '10:57:11';
29
SELECT count(*) FROM timetmp WHERE a > '10:57:11';
35
CREATE INDEX timeidx ON timetmp USING gist ( a );
36
SET enable_seqscan=off;
37
SELECT count(*) FROM timetmp WHERE a < '10:57:11'::time;
43
SELECT count(*) FROM timetmp WHERE a <= '10:57:11'::time;
49
SELECT count(*) FROM timetmp WHERE a = '10:57:11'::time;
55
SELECT count(*) FROM timetmp WHERE a >= '10:57:11'::time;
61
SELECT count(*) FROM timetmp WHERE a > '10:57:11'::time;