char8.out 2.13 KB
Newer Older
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 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105
QUERY: CREATE TABLE CHAR8_TBL(f1 char8);
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('ABCDEFGH');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('abcdefgh');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('ZYWZ410-');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('343f%2a');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('d34aas');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('1234567890');
QUERY: SELECT '' AS seven, CHAR8_TBL.*;
seven|f1      
-----+--------
     |ABCDEFGH
     |abcdefgh
     |ZYWZ410-
     |343f%2a 
     |d34aas  
     |        
     |12345678
(7 rows)

QUERY: SELECT '' AS six, c.f1 FROM CHAR8_TBL c WHERE c.f1 <> 'ABCDEFGH';
six|f1      
---+--------
   |abcdefgh
   |ZYWZ410-
   |343f%2a 
   |d34aas  
   |        
   |12345678
(6 rows)

QUERY: SELECT '' AS one, c.f1 FROM CHAR8_TBL c WHERE c.f1 = 'ABCDEFGH';
one|f1      
---+--------
   |ABCDEFGH
(1 row)

QUERY: SELECT '' AS three, c.f1 FROM CHAR8_TBL c WHERE c.f1 < 'ABCDEFGH';
three|f1      
-----+--------
     |343f%2a 
     |        
     |12345678
(3 rows)

QUERY: SELECT '' AS four, c.f1 FROM CHAR8_TBL c WHERE c.f1 <= 'ABCDEFGH';
four|f1      
----+--------
    |ABCDEFGH
    |343f%2a 
    |        
    |12345678
(4 rows)

QUERY: SELECT '' AS three, c.f1 FROM CHAR8_TBL c WHERE c.f1 > 'ABCDEFGH';
three|f1      
-----+--------
     |abcdefgh
     |ZYWZ410-
     |d34aas  
(3 rows)

QUERY: SELECT '' AS four, c.f1 FROM CHAR8_TBL c WHERE c.f1 >= 'ABCDEFGH';
four|f1      
----+--------
    |ABCDEFGH
    |abcdefgh
    |ZYWZ410-
    |d34aas  
(4 rows)

QUERY: SELECT '' AS seven, c.f1 FROM CHAR8_TBL c WHERE c.f1 ~ '.*';
seven|f1      
-----+--------
     |ABCDEFGH
     |abcdefgh
     |ZYWZ410-
     |343f%2a 
     |d34aas  
     |        
     |12345678
(7 rows)

QUERY: SELECT '' AS zero, c.f1 FROM CHAR8_TBL c WHERE c.f1 !~ '.*';
zero|f1
----+--
(0 rows)

QUERY: SELECT '' AS four, c.f1 FROM CHAR8_TBL c WHERE c.f1 ~ '[0-9]';
four|f1      
----+--------
    |ZYWZ410-
    |343f%2a 
    |d34aas  
    |12345678
(4 rows)

QUERY: SELECT '' AS three, c.f1 FROM CHAR8_TBL c WHERE c.f1 ~ '.*34.*';
three|f1      
-----+--------
     |343f%2a 
     |d34aas  
     |12345678
(3 rows)