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