contrib/btree_gist/sql/oid.sql

-- oid check

SET enable_seqscan=on;

CREATE TEMPORARY TABLE oidtmp (oid oid);
INSERT INTO oidtmp SELECT g.i::oid FROM generate_series(1, 1000) g(i);

SELECT count(*) FROM oidtmp WHERE oid <  17;

SELECT count(*) FROM oidtmp WHERE oid <= 17;

SELECT count(*) FROM oidtmp WHERE oid  = 17;

SELECT count(*) FROM oidtmp WHERE oid >= 17;

SELECT count(*) FROM oidtmp WHERE oid >  17;

CREATE INDEX oididx ON oidtmp USING gist ( oid );

SET enable_seqscan=off;

SELECT count(*) FROM oidtmp WHERE oid <  17;

SELECT count(*) FROM oidtmp WHERE oid <= 17;

SELECT count(*) FROM oidtmp WHERE oid  = 17;

SELECT count(*) FROM oidtmp WHERE oid >= 17;

SELECT count(*) FROM oidtmp WHERE oid >  17;