Upper / lower case keys in JSON objects

Поиск
Список
Период
Сортировка
От Mark
Тема Upper / lower case keys in JSON objects
Дата
Msg-id CAAm-KOuSB+mS=k3LjYLCwpkv64EpWqF8OCA=jzwCofnjyqsgXA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Upper / lower case keys in JSON objects
Re: Upper / lower case keys in JSON objects
Список pgsql-general
Дерево обсуждения
Hi all 

Apologies for any unexpected protocol exceptions, I do not post to mailing lists very often

I have been trying to work with JSON objects and noticed I could not get the function json_to_record to produce results, unless I had the key values in lower case, through testing what works.

I completed a search, but could not find any pointer (except for some front end comments on labels being all upper or all lower case)

Could anybody comment if the postgres standard is to have key labels in lower case?

Many thanks for any help you can provide

Mark 

query:
select * from json_to_record('{"secLvl": 13, "firBal": "somethi", "firLvl": "C", "thiLvl": "A", "fourLvl": 2}'::json) as x(seclvl int, firbal text, firlvl text
, thilvl text, fourlvl int);

result:
seclvl | firbal | firlvl | thilvl | fourlvl  
--------+--------+--------+--------+---------
       |        |        |        |         
(1 row)


query:
select * from json_to_record('{"seclvl": 13, "firbal": "somethi", "firlvl": "C", "thilvl": "A", "fourlvl": 2}'::json) as x(seclvl int, firbal text, firlvl text
, thilvl text, fourlvl int);

result:
seclvl | firbal  | firlvl | thilvl | fourlvl  
--------+---------+--------+--------+---------
    13 | somethi | C      | A      |       2
(1 row)

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