MIME-Version: 1.0
From: Mark <nvpostgres@gmail.com>
Date: Fri, 25 Jul 2025 13:26:16 +0100
Message-ID: <CAAm-KOuSB+mS=k3LjYLCwpkv64EpWqF8OCA=jzwCofnjyqsgXA@mail.gmail.com>
Subject: Upper / lower case keys in JSON objects
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001edd7e063ac00e30"
Archived-At: <https://www.postgresql.org/message-id/CAAm-KOuSB%2BmS%3Dk3LjYLCwpkv64EpWqF8OCA%3DjzwCofnjyqsgXA%40mail.gmail.com>
Precedence: bulk

--0000000000001edd7e063ac00e30
Content-Type: text/plain; charset="UTF-8"

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)

--0000000000001edd7e063ac00e30
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi all=C2=A0</div><div><br></div><div>Apologies for a=
ny unexpected protocol exceptions, I do not post to mailing lists very ofte=
n</div><div><br></div><div>I
 have been trying to work with JSON objects and noticed I could not get=20
the function json_to_record to produce results, unless I had the key=20
values in lower case, through testing what works.</div><div><br></div><div>=
I
 completed a search, but could not find any pointer (except for some=20
front end comments on labels being all upper or all lower case)</div><div><=
br></div><div>Could anybody comment if the postgres standard is to have key=
 labels in lower case?</div><div><br></div><div>Many thanks for any help yo=
u can provide</div><div><br></div><div>Mark=C2=A0</div><div><br></div><div>=
query:</div><div><span style=3D"font-family:monospace"><span style=3D"color=
:rgb(0,0,0);background-color:rgb(255,255,255)">select
 * from json_to_record(&#39;{&quot;secLvl&quot;: 13, &quot;firBal&quot;: &q=
uot;somethi&quot;, &quot;firLvl&quot;:=20
&quot;C&quot;, &quot;thiLvl&quot;: &quot;A&quot;, &quot;fourLvl&quot;: 2}&#=
39;::json) as x(seclvl int, firbal text,=20
firlvl text</span></span></div><div><span style=3D"font-family:monospace"><=
/span></div><span style=3D"font-family:monospace">, thilvl text, fourlvl in=
t);<br></span><div><br></div><div>result:</div><span style=3D"font-family:m=
onospace"><span style=3D"color:rgb(0,0,0);background-color:rgb(255,255,255)=
">seclvl | firbal | firlvl | thilvl | fourlvl </span><span style=3D"color:r=
gb(0,0,0);background-color:rgb(255,255,255)">=C2=A0</span><br><span style=
=3D"color:rgb(0,0,0);background-color:rgb(255,255,255)">--------+--------+-=
-------+--------+---------</span><span style=3D"color:rgb(0,0,0);background=
-color:rgb(255,255,255)">
</span><br><span style=3D"color:rgb(0,0,0);background-color:rgb(255,255,255=
)"> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0| =C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0| =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0| =C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0| =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0<=
/span><span style=3D"color:rgb(0,0,0);background-color:rgb(255,255,255)">=
=C2=A0</span><br><span style=3D"color:rgb(0,0,0);background-color:rgb(255,2=
55,255)">(1 row)</span><br></span><div><br></div><div><div><br></div><div>q=
uery:</div></div>


<span style=3D"font-family:monospace"><span style=3D"color:rgb(0,0,0);backg=
round-color:rgb(255,255,255)">select
 * from json_to_record(&#39;{&quot;seclvl&quot;: 13, &quot;firbal&quot;: &q=
uot;somethi&quot;, &quot;firlvl&quot;:=20
&quot;C&quot;, &quot;thilvl&quot;: &quot;A&quot;, &quot;fourlvl&quot;: 2}&#=
39;::json) as x(seclvl int, firbal text,=20
firlvl text</span><br>, thilvl text, fourlvl int);<br></span><div><br></div=
><div>result:</div><div>


<span style=3D"font-family:monospace"><span style=3D"color:rgb(0,0,0);backg=
round-color:rgb(255,255,255)"> seclvl | firbal =C2=A0| firlvl | thilvl | fo=
urlvl </span><span style=3D"color:rgb(0,0,0);background-color:rgb(255,255,2=
55)">=C2=A0</span><br><span style=3D"color:rgb(0,0,0);background-color:rgb(=
255,255,255)">--------+---------+--------+--------+---------</span><span st=
yle=3D"color:rgb(0,0,0);background-color:rgb(255,255,255)">
</span><br><span style=3D"color:rgb(0,0,0);background-color:rgb(255,255,255=
)"> =C2=A0=C2=A0=C2=A0=C2=A013 | somethi | C =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
| A =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0| =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A02</=
span><span style=3D"color:rgb(0,0,0);background-color:rgb(255,255,255)">
</span><br><span style=3D"color:rgb(0,0,0);background-color:rgb(255,255,255=
)">(1 row)</span><br></span>

</div><br></div>

--0000000000001edd7e063ac00e30--