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