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

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