summaryrefslogtreecommitdiffstats
path: root/contrib/btree_gist/expected/oid.out
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/btree_gist/expected/oid.out')
-rw-r--r--contrib/btree_gist/expected/oid.out66
1 files changed, 66 insertions, 0 deletions
diff --git a/contrib/btree_gist/expected/oid.out b/contrib/btree_gist/expected/oid.out
new file mode 100644
index 0000000..776bbb1
--- /dev/null
+++ b/contrib/btree_gist/expected/oid.out
@@ -0,0 +1,66 @@
+-- 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;
+ count
+-------
+ 16
+(1 row)
+
+SELECT count(*) FROM oidtmp WHERE oid <= 17;
+ count
+-------
+ 17
+(1 row)
+
+SELECT count(*) FROM oidtmp WHERE oid = 17;
+ count
+-------
+ 1
+(1 row)
+
+SELECT count(*) FROM oidtmp WHERE oid >= 17;
+ count
+-------
+ 984
+(1 row)
+
+SELECT count(*) FROM oidtmp WHERE oid > 17;
+ count
+-------
+ 983
+(1 row)
+
+CREATE INDEX oididx ON oidtmp USING gist ( oid );
+SET enable_seqscan=off;
+SELECT count(*) FROM oidtmp WHERE oid < 17;
+ count
+-------
+ 16
+(1 row)
+
+SELECT count(*) FROM oidtmp WHERE oid <= 17;
+ count
+-------
+ 17
+(1 row)
+
+SELECT count(*) FROM oidtmp WHERE oid = 17;
+ count
+-------
+ 1
+(1 row)
+
+SELECT count(*) FROM oidtmp WHERE oid >= 17;
+ count
+-------
+ 984
+(1 row)
+
+SELECT count(*) FROM oidtmp WHERE oid > 17;
+ count
+-------
+ 983
+(1 row)
+