postgres=# SELECT U&"d\0061t\+000061";
ERROR: column "data" does not exist
LINE 1: SELECT U&"d\0061t\+000061";
^
postgres=# SELECT U&"\0441\043B\043E\043D";
ERROR: column "слон" does not exist
LINE 1: SELECT U&"\0441\043B\043E\043D";
^
postgres=# SELECT U&"d!0061t!+000061" UESCAPE '!';
ERROR: column "data" does not exist
LINE 1: SELECT U&"d!0061t!+000061" UESCAPE '!';
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/sql-syntax-lexical.html
Description:
Why repeat information within the same section?
4.1.1 and 4.1.2 are rightly written so as to keep them independent of one another. It in part avoids wordiness in dealing with the fact that identifiers use double quotes while string literals use single quotes.
In Section 4.1.1, “Identifiers and Keywords”:
> U&“d\0061t\+000061”
This information, along with examples, is also provided in Section 4.1.2.3.
String Constants with Escaped Unicode Characters
> U&'d\0061t\+000061'
Thus while these are indeed both similar to each other the so-called repetition is warranted.
David J.
