oidint2.out 1.62 KB
Newer Older
1 2 3 4 5 6
QUERY: CREATE TABLE OIDINT2_TBL(f1 oidint2);
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('1234/9873');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('1235/9873');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('987/-1234');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('123456');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('123456/123456');
7
ERROR:  pg_atoi: error reading "123456": Math result not representable
8 9
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('asdfasd');
10
ERROR:  pg_atoi: error in "asdfasd": can't parse "asdfasd"
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 65
QUERY: SELECT '' AS five, OIDINT2_TBL.*;
five|f1       
----+---------
    |1234/9873
    |1235/9873
    |987/-1234
    |123456/0 
    |0/0      
(5 rows)

QUERY: SELECT '' AS one, o.* FROM OIDINT2_TBL o WHERE o.f1 = '1235/9873';
one|f1       
---+---------
   |1235/9873
(1 row)

QUERY: SELECT '' AS four, o.* FROM OIDINT2_TBL o WHERE o.f1 <> '1235/9873';
four|f1       
----+---------
    |1234/9873
    |987/-1234
    |123456/0 
    |0/0      
(4 rows)

QUERY: SELECT '' AS four, o.* FROM OIDINT2_TBL o WHERE o.f1 <= '1235/9873';
four|f1       
----+---------
    |1234/9873
    |1235/9873
    |987/-1234
    |0/0      
(4 rows)

QUERY: SELECT '' AS three, o.* FROM OIDINT2_TBL o WHERE o.f1 < '1235/9873';
three|f1       
-----+---------
     |1234/9873
     |987/-1234
     |0/0      
(3 rows)

QUERY: SELECT '' AS two, o.* FROM OIDINT2_TBL o WHERE o.f1 >= '1235/9873';
two|f1       
---+---------
   |1235/9873
   |123456/0 
(2 rows)

QUERY: SELECT '' AS one, o.* FROM OIDINT2_TBL o WHERE o.f1 > '1235/9873';
one|f1      
---+--------
   |123456/0
(1 row)

66
QUERY: DROP TABLE  OIDINT2_TBL;