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