1 files changed, 30 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/oid.sql b/contrib/btree_gist/sql/oid.sql
new file mode 100644
index 0000000..c935823
--- /dev/null
+++ b/contrib/btree_gist/sql/oid.sql
@@ -0,0 +1,30 @@
+-- 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;