Re: BUG #16092: json[b]_to_recordset and json[b]_populate_record do not read properties with mixed-case names

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: BUG #16092: json[b]_to_recordset and json[b]_populate_record do not read properties with mixed-case names
Дата
Msg-id 12615741572532914@myt2-c3952fd46804.qloud-c.yandex.net
обсуждение исходный текст
Ответ на BUG #16092: json[b]_to_recordset and json[b]_populate_record do not read properties with mixed-case names  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Hello

Its correct. Identifier name definition should be quoted if you want use uppercase symbols:

SELECT x.* FROM jsonb_to_recordset('[{"aName": "foo"}]'::jsonb) AS x("aName" text);

 aName 
-------
 foo

unquoted names are always folded to lower case and therefore do not match. Per lexical structure documentation:
https://www.postgresql.org/docs/current/sql-syntax-lexical.html

regards, Sergei



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: a error happends when create a table in postgresql10.ubuntu18.04
Следующее
От: Alexey Ermakov
Дата:
Сообщение: Re: BUG #16016: deadlock with startup process, AccessExclusiveLockon pg_statistic's toast table