blob: 0aa6675e21dafbab2040cd1dd424892fd4380e9b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
QUERY: CREATE TABLE OID_TBL(f1 oid);
QUERY: INSERT INTO OID_TBL(f1) VALUES ('1234');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('1235');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('987');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('-1040');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
ERROR: pg_atoi: error in "asdfasd": can't parse "asdfasd"
QUERY: SELECT '' AS five, OID_TBL.*;
five| f1
----+-----
| 1234
| 1235
| 987
|-1040
| 0
(5 rows)
QUERY: SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = '1234'::oid;
one| f1
---+----
|1234
(1 row)
QUERY: SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 <> '1234';
four| f1
----+-----
| 1235
| 987
|-1040
| 0
(4 rows)
QUERY: SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 <= '1234';
four| f1
----+-----
| 1234
| 987
|-1040
| 0
(4 rows)
QUERY: SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 < '1234';
three| f1
-----+-----
| 987
|-1040
| 0
(3 rows)
QUERY: SELECT '' AS two, o.* FROM OID_TBL o WHERE o.f1 >= '1234';
two| f1
---+----
|1234
|1235
(2 rows)
QUERY: SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 > '1234';
one| f1
---+----
|1235
(1 row)
QUERY: DROP TABLE OID_TBL;
|
