On 7/25/25 05:26, Mark wrote:
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
Sorry all,
Figured it out, the following works:
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
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 com
