1
set enable_seqscan=off;
2
CREATE TABLE test_time (
5
INSERT INTO test_time VALUES
13
CREATE INDEX idx_time ON test_time USING gin (i);
14
SELECT * FROM test_time WHERE i<'08:55:08'::time ORDER BY i;
22
SELECT * FROM test_time WHERE i<='08:55:08'::time ORDER BY i;
31
SELECT * FROM test_time WHERE i='08:55:08'::time ORDER BY i;
37
SELECT * FROM test_time WHERE i>='08:55:08'::time ORDER BY i;
45
SELECT * FROM test_time WHERE i>'08:55:08'::time ORDER BY i;