btree_gist/sql/date.sql

3 CREATE TABLE datetmp (a date);  table
5 \copy datetmp from 'data/date.data'
9 SELECT count(*) FROM datetmp WHERE a <  '2001-02-13';
11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13';
13 SELECT count(*) FROM datetmp WHERE a  = '2001-02-13';
15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13';
17 SELECT count(*) FROM datetmp WHERE a >  '2001-02-13';
19 SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
21 CREATE INDEX dateidx ON datetmp USING gist ( a );
25 SELECT count(*) FROM datetmp WHERE a <  '2001-02-13'::date;
27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date;
29 SELECT count(*) FROM datetmp WHERE a  = '2001-02-13'::date;
31 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'::date;
33 SELECT count(*) FROM datetmp WHERE a >  '2001-02-13'::date;
36 SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
37 SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;