3
CREATE TABLE timetmp (a time);
5
\copy timetmp from 'data/time.data'
9
SELECT count(*) FROM timetmp WHERE a < '10:57:11';
11
SELECT count(*) FROM timetmp WHERE a <= '10:57:11';
13
SELECT count(*) FROM timetmp WHERE a = '10:57:11';
15
SELECT count(*) FROM timetmp WHERE a >= '10:57:11';
17
SELECT count(*) FROM timetmp WHERE a > '10:57:11';
19
CREATE INDEX timeidx ON timetmp USING gist ( a );
21
SET enable_seqscan=off;
23
SELECT count(*) FROM timetmp WHERE a < '10:57:11'::time;
25
SELECT count(*) FROM timetmp WHERE a <= '10:57:11'::time;
27
SELECT count(*) FROM timetmp WHERE a = '10:57:11'::time;
29
SELECT count(*) FROM timetmp WHERE a >= '10:57:11'::time;
31
SELECT count(*) FROM timetmp WHERE a > '10:57:11'::time;