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
|
SELECT '';
SELECT '''';
SELECT '
';
SELECT '''aaa''';
SELECT '
''
';
SELECT '\';
SELECT 'foo'
'bar';
SELECT 'foo'
'bar';
SELECT 'foo'
'bar';
SELECT 'foo' -- some comment
'bar';
COMMENT ON TABLE "some_table" IS E''
'This is a valid comment style'
'\n\n'
'which is escaped';
SELECT
e'da' --this is a comment
'ta';
SELECT
e'value of newline here:
'
'space '
'no'
'space';
SELECT U&''
'd\0061t\+000061'
' which has unicode',
U&'d!0061t!+000061'
' which has unicode' UESCAPE '!',
u&'d!0061t!+000061 which has unicode' uescape '!';
SELECT b''
'000'
'010'
'101';
SELECT x'1234'
'abcd'
'dead'
'beEF';
SELECT e'two '
'line',
E'can have single quotes escaped this way: \' ',
e'but the second line'
'requires it like this '' \n\n';
|
