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