1set enable_seqscan=off; 2 3CREATE TABLE test_interval ( 4 i interval 5); 6 7INSERT INTO test_interval VALUES 8 ( '03:55:08' ), 9 ( '04:55:08' ), 10 ( '05:55:08' ), 11 ( '08:55:08' ), 12 ( '09:55:08' ), 13 ( '10:55:08' ) 14; 15 16CREATE INDEX idx_interval ON test_interval USING gin (i); 17 18SELECT * FROM test_interval WHERE i<'08:55:08'::interval ORDER BY i; 19SELECT * FROM test_interval WHERE i<='08:55:08'::interval ORDER BY i; 20SELECT * FROM test_interval WHERE i='08:55:08'::interval ORDER BY i; 21SELECT * FROM test_interval WHERE i>='08:55:08'::interval ORDER BY i; 22SELECT * FROM test_interval WHERE i>'08:55:08'::interval ORDER BY i; 23