rum/sql/bit.sql at master · postgrespro/rum · GitHub

Name: rum/sql/bit.sql at master · postgrespro/rum · GitHub
Rating: 4.6 (9492 reviews)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
set enable_seqscan=off;

CREATETABLEtest_bit (
 i bit(3)
);

INSERT INTO test_bit VALUES ('001'),('010'),('011'),('100'),('101'),('110');

CREATEINDEXidx_bitON test_bit USING rum (i);

SELECT*FROM test_bit WHERE i<'100'::bit(3) ORDER BY i;
SELECT*FROM test_bit WHERE i<='100'::bit(3) ORDER BY i;
SELECT*FROM test_bit WHERE i='100'::bit(3) ORDER BY i;
SELECT*FROM test_bit WHERE i>='100'::bit(3) ORDER BY i;
SELECT*FROM test_bit WHERE i>'100'::bit(3) ORDER BY i;