1set enable_seqscan=off; 2 3CREATE TABLE test_money ( 4 i money 5); 6 7INSERT INTO test_money VALUES ('-2'),('-1'),('0'),('1'),('2'),('3'); 8 9CREATE INDEX idx_money ON test_money USING gin (i); 10 11SELECT * FROM test_money WHERE i<'1'::money ORDER BY i; 12SELECT * FROM test_money WHERE i<='1'::money ORDER BY i; 13SELECT * FROM test_money WHERE i='1'::money ORDER BY i; 14SELECT * FROM test_money WHERE i>='1'::money ORDER BY i; 15SELECT * FROM test_money WHERE i>'1'::money ORDER BY i; 16