blob: 62a4e06417882a962a5377567e0e3b8f9b63bca1 (
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
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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
QUERY: SELECT 'first line'
' - next line'
' - third line'
AS "Three lines to one";
Three lines to one
-----------------------------------
first line - next line - third line
(1 row)
QUERY: SELECT 'first line'
' - next line' /* this comment is not allowed here */
' - third line'
AS "Illegal comment within continuation";
ERROR: parser: parse error at or near "'"
QUERY: SELECT CAST(f1 AS text) AS "text(char)" FROM CHAR_TBL;
text(char)
----------
a
ab
abcd
abcd
(4 rows)
QUERY: SELECT CAST(f1 AS text) AS "text(varchar)" FROM VARCHAR_TBL;
text(varchar)
-------------
a
ab
abcd
abcd
(4 rows)
QUERY: SELECT CAST(name 'namefield' AS text) AS "text(name)";
text(name)
----------
namefield
(1 row)
QUERY: SELECT CAST(f1 AS char) AS "char(text)" FROM TEXT_TBL;
char(text)
-----------------
doh!
hi de ho neighbor
(2 rows)
QUERY: SELECT CAST(f1 AS char) AS "char(varchar)" FROM VARCHAR_TBL;
char(varchar)
-------------
a
ab
abcd
abcd
(4 rows)
QUERY: SELECT CAST(name 'namefield' AS char) AS "char(name)";
char(name)
----------
namefield
(1 row)
QUERY: SELECT CAST(f1 AS varchar) AS "varchar(text)" FROM TEXT_TBL;
varchar(text)
-----------------
doh!
hi de ho neighbor
(2 rows)
QUERY: SELECT CAST(f1 AS varchar) AS "varchar(char)" FROM CHAR_TBL;
varchar(char)
-------------
a
ab
abcd
abcd
(4 rows)
QUERY: SELECT CAST(name 'namefield' AS varchar) AS "varchar(name)";
varchar(name)
-------------
namefield
(1 row)
QUERY: SELECT TRIM(BOTH FROM ' bunch o blanks ') AS "bunch o blanks";
bunch o blanks
--------------
bunch o blanks
(1 row)
QUERY: SELECT TRIM(LEADING FROM ' bunch o blanks ') AS "bunch o blanks ";
bunch o blanks
----------------
bunch o blanks
(1 row)
QUERY: SELECT TRIM(TRAILING FROM ' bunch o blanks ') AS " bunch o blanks";
bunch o blanks
----------------
bunch o blanks
(1 row)
QUERY: SELECT TRIM(BOTH 'x' FROM 'xxxxxsome Xsxxxxx') AS "some Xs";
some Xs
-------
some Xs
(1 row)
QUERY: SELECT SUBSTRING('1234567890' FROM 3) AS "34567890";
34567890
--------
34567890
(1 row)
QUERY: SELECT SUBSTRING('1234567890' FROM 4 FOR 3) AS "456";
456
---
456
(1 row)
QUERY: SELECT POSITION('4' IN '1234567890') AS "4";
4
-
4
(1 row)
QUERY: SELECT POSITION(5 IN '1234567890') AS "5";
5
-
5
(1 row)
QUERY: SELECT 'unknown' || ' and unknown' AS "Concat unknown types";
Concat unknown types
--------------------
unknown and unknown
(1 row)
QUERY: SELECT text 'text' || ' and unknown' AS "Concat text to unknown type";
Concat text to unknown type
---------------------------
text and unknown
(1 row)
QUERY: SELECT text 'text' || char ' and char' AS "Concat text to char";
Concat text to char
-------------------
text and char
(1 row)
QUERY: SELECT text 'text' || varchar ' and varchar' AS "Concat text to varchar";
Concat text to varchar
----------------------
text and varchar
(1 row)
|
