1--
2-- OID
3--
4CREATE TABLE OID_TBL(f1 oid);
5INSERT INTO OID_TBL(f1) VALUES ('1234');
6INSERT INTO OID_TBL(f1) VALUES ('1235');
7INSERT INTO OID_TBL(f1) VALUES ('987');
8INSERT INTO OID_TBL(f1) VALUES ('-1040');
9INSERT INTO OID_TBL(f1) VALUES ('99999999');
10INSERT INTO OID_TBL(f1) VALUES ('5     ');
11INSERT INTO OID_TBL(f1) VALUES ('   10  ');
12-- leading/trailing hard tab is also allowed
13INSERT INTO OID_TBL(f1) VALUES ('	  15 	  ');
14-- bad inputs
15INSERT INTO OID_TBL(f1) VALUES ('');
16ERROR:  invalid input syntax for type oid: ""
17LINE 1: INSERT INTO OID_TBL(f1) VALUES ('');
18                                        ^
19INSERT INTO OID_TBL(f1) VALUES ('    ');
20ERROR:  invalid input syntax for type oid: "    "
21LINE 1: INSERT INTO OID_TBL(f1) VALUES ('    ');
22                                        ^
23INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
24ERROR:  invalid input syntax for type oid: "asdfasd"
25LINE 1: INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
26                                        ^
27INSERT INTO OID_TBL(f1) VALUES ('99asdfasd');
28ERROR:  invalid input syntax for type oid: "99asdfasd"
29LINE 1: INSERT INTO OID_TBL(f1) VALUES ('99asdfasd');
30                                        ^
31INSERT INTO OID_TBL(f1) VALUES ('5    d');
32ERROR:  invalid input syntax for type oid: "5    d"
33LINE 1: INSERT INTO OID_TBL(f1) VALUES ('5    d');
34                                        ^
35INSERT INTO OID_TBL(f1) VALUES ('    5d');
36ERROR:  invalid input syntax for type oid: "    5d"
37LINE 1: INSERT INTO OID_TBL(f1) VALUES ('    5d');
38                                        ^
39INSERT INTO OID_TBL(f1) VALUES ('5    5');
40ERROR:  invalid input syntax for type oid: "5    5"
41LINE 1: INSERT INTO OID_TBL(f1) VALUES ('5    5');
42                                        ^
43INSERT INTO OID_TBL(f1) VALUES (' - 500');
44ERROR:  invalid input syntax for type oid: " - 500"
45LINE 1: INSERT INTO OID_TBL(f1) VALUES (' - 500');
46                                        ^
47INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935');
48ERROR:  value "32958209582039852935" is out of range for type oid
49LINE 1: INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935');
50                                        ^
51INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385');
52ERROR:  value "-23582358720398502385" is out of range for type oid
53LINE 1: INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385');
54                                        ^
55SELECT '' AS six, * FROM OID_TBL;
56 six |     f1
57-----+------------
58     |       1234
59     |       1235
60     |        987
61     | 4294966256
62     |   99999999
63     |          5
64     |         10
65     |         15
66(8 rows)
67
68SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234;
69 one |  f1
70-----+------
71     | 1234
72(1 row)
73
74SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234';
75 five |     f1
76------+------------
77      |       1235
78      |        987
79      | 4294966256
80      |   99999999
81      |          5
82      |         10
83      |         15
84(7 rows)
85
86SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234';
87 three |  f1
88-------+------
89       | 1234
90       |  987
91       |    5
92       |   10
93       |   15
94(5 rows)
95
96SELECT '' AS two, o.* FROM OID_TBL o WHERE o.f1 < '1234';
97 two | f1
98-----+-----
99     | 987
100     |   5
101     |  10
102     |  15
103(4 rows)
104
105SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234';
106 four |     f1
107------+------------
108      |       1234
109      |       1235
110      | 4294966256
111      |   99999999
112(4 rows)
113
114SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234';
115 three |     f1
116-------+------------
117       |       1235
118       | 4294966256
119       |   99999999
120(3 rows)
121
122DROP TABLE OID_TBL;
123