Re: BUG #18619: uppercase column with quotation marks, gets an error without quotation marks

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: BUG #18619: uppercase column with quotation marks, gets an error without quotation marks
Дата
Msg-id CA+bJJbyoF=sRMcpzuAxwQDxp7YEJND=kQCzqn4a7yJtFRj7sbg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #18619: uppercase column with quotation marks, gets an error without quotation marks  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
On Mon, 16 Sept 2024 at 09:42, PG Bug reporting form
<noreply@postgresql.org> wrote:
> The following bug has been logged on the website:
> If you create a table with field names in uppercase and put them in
> quotation marks.
> then such fields can be accessed only with quotation marks.

Not a bug, but a long known std deviation. Read
https://www.postgresql.org/docs/17/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
. You would have the same problem with std swapping upper and lower.

Francisco Olarte.



В списке pgsql-bugs по дате отправления: