1-- oid check 2SET enable_seqscan=on; 3CREATE TEMPORARY TABLE oidtmp (oid oid); 4INSERT INTO oidtmp SELECT g.i::oid FROM generate_series(1, 1000) g(i); 5SELECT count(*) FROM oidtmp WHERE oid < 17; 6 count 7------- 8 16 9(1 row) 10 11SELECT count(*) FROM oidtmp WHERE oid <= 17; 12 count 13------- 14 17 15(1 row) 16 17SELECT count(*) FROM oidtmp WHERE oid = 17; 18 count 19------- 20 1 21(1 row) 22 23SELECT count(*) FROM oidtmp WHERE oid >= 17; 24 count 25------- 26 984 27(1 row) 28 29SELECT count(*) FROM oidtmp WHERE oid > 17; 30 count 31------- 32 983 33(1 row) 34 35CREATE INDEX oididx ON oidtmp USING gist ( oid ); 36SET enable_seqscan=off; 37SELECT count(*) FROM oidtmp WHERE oid < 17; 38 count 39------- 40 16 41(1 row) 42 43SELECT count(*) FROM oidtmp WHERE oid <= 17; 44 count 45------- 46 17 47(1 row) 48 49SELECT count(*) FROM oidtmp WHERE oid = 17; 50 count 51------- 52 1 53(1 row) 54 55SELECT count(*) FROM oidtmp WHERE oid >= 17; 56 count 57------- 58 984 59(1 row) 60 61SELECT count(*) FROM oidtmp WHERE oid > 17; 62 count 63------- 64 983 65(1 row) 66 67