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
|
-- Examples from https://cloud.google.com/bigquery/docs/reference/standard-sql/lexical#string_and_bytes_literals
SELECT
"",
'',
"abc",
"it's",
'it\'s',
'Title: "Boy"',
"test \"escaped\"",
'test \'escaped\'',
"test \\\"escaped",
"test \"escaped\\\"",
r"",
r'',
r"abc+",
R"abc+",
r'abc+',
R'abc+',
r'f\(abc, (.*),def\)',
r"f\(abc, (.*),def\)",
b'abc',
B"abc",
rb"abc*",
rB"abc*",
Rb'abc*',
br'abc+',
RB"abc+",
r''' as foo '' bar ''',
B""" triple ''' quoted '' "" string are """ as hard
FROM dummy
|