2
CREATE TABLE datetmp (a date);
3
\copy datetmp from 'data/date.data'
5
SELECT count(*) FROM datetmp WHERE a < '2001-02-13';
11
SELECT count(*) FROM datetmp WHERE a <= '2001-02-13';
17
SELECT count(*) FROM datetmp WHERE a = '2001-02-13';
23
SELECT count(*) FROM datetmp WHERE a >= '2001-02-13';
29
SELECT count(*) FROM datetmp WHERE a > '2001-02-13';
35
SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
37
------------+----------
43
CREATE INDEX dateidx ON datetmp USING gist ( a );
44
SET enable_seqscan=off;
45
SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date;
51
SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date;
57
SELECT count(*) FROM datetmp WHERE a = '2001-02-13'::date;
63
SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'::date;
69
SELECT count(*) FROM datetmp WHERE a > '2001-02-13'::date;
76
SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
78
----------------------------------------------
80
-> Index Scan using dateidx on datetmp
81
Order By: (a <-> '02-13-2001'::date)
84
SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
86
------------+----------