1set enable_seqscan=off; 2 3CREATE TABLE test_date ( 4 i date 5); 6 7INSERT INTO test_date VALUES 8 ( '2004-10-23' ), 9 ( '2004-10-24' ), 10 ( '2004-10-25' ), 11 ( '2004-10-26' ), 12 ( '2004-10-27' ), 13 ( '2004-10-28' ) 14; 15 16CREATE INDEX idx_date ON test_date USING gin (i); 17 18SELECT * FROM test_date WHERE i<'2004-10-26'::date ORDER BY i; 19SELECT * FROM test_date WHERE i<='2004-10-26'::date ORDER BY i; 20SELECT * FROM test_date WHERE i='2004-10-26'::date ORDER BY i; 21SELECT * FROM test_date WHERE i>='2004-10-26'::date ORDER BY i; 22SELECT * FROM test_date WHERE i>'2004-10-26'::date ORDER BY i; 23