Date: Tue, 26 Nov 2024 06:34:06 -0500
From: Tim McLaughlin <tim@gotab.io>
To: pgsql-general@lists.postgresql.org
Message-ID: <536dca0f-ef1a-4621-ac1f-9c1c1dd74fbd@Spark>
Subject: change JSON serialization for BIGINT?
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="6745b233_4f4ef005_1066"
Archived-At: <https://www.postgresql.org/message-id/536dca0f-ef1a-4621-ac1f-9c1c1dd74fbd%40Spark>
Precedence: bulk

--6745b233_4f4ef005_1066
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Is there a way to have Postgres serialize BIGINT as a string rather than =
number in JSON=3F=C2=A0=C2=A0By default it does this:


select row=5Fto=5Fjson(row(500::bigint));
=C2=A0row=5Fto=5Fjson
-------------
=C2=A0=7B=22f1=22:500=7D

But I want it to do this (note that =22500=22 is quoted):

select row=5Fto=5Fjson(row(500::bigint));
=C2=A0row=5Fto=5Fjson
-------------
=C2=A0=7B=22f1=22:=22500=22=7D

I tried doing this, but it has no effect:

CREATE or replace =46UNCTION bigintJson(bigint) RETURNS json
=C2=A0=C2=A0 =C2=A0AS 'select =241::text::json;'
=C2=A0=C2=A0 =C2=A0LANGUAGE SQL IMMUTABLE RETURNS NULL ON NULL INPUT;

create cast (bigint as json) with function bigintJson(bigint) as implicit=
;

Thanks for any guidance.

--
Tim McLaughlin

--6745b233_4f4ef005_1066
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<html xmlns=3D=22http://www.w3.org/1999/xhtml=22>
<head>
<title></title>
</head>
<body>
<div name=3D=22messageBodySection=22>
<div dir=3D=22auto=22>Is there a way to have Postgres serialize BIGINT as=
 a string rather than number in JSON=3F&=23160;&=23160;By default it does=
 this:<br />
<br />
<br />
select row=5Fto=5Fjson(row(500::bigint));<br />
&=23160;row=5Fto=5Fjson&=23160;<br />
-------------<br />
&=23160;=7B=22f1=22:500=7D<br />
<br />
But I want it to do this (note that =22500=22 is quoted):<br />
<br />
select row=5Fto=5Fjson(row(500::bigint));<br />
&=23160;row=5Fto=5Fjson&=23160;<br />
-------------<br />
&=23160;=7B=22f1=22:=22500=22=7D<br />
<br />
I tried doing this, but it has no effect:<br />
<br />
CREATE or replace =46UNCTION bigintJson(bigint) RETURNS json<br />
&=23160;&=23160; &=23160;AS 'select =241::text::json;'<br />
&=23160;&=23160; &=23160;LANGUAGE SQL IMMUTABLE RETURNS NULL ON NULL INPU=
T;<br />
<br />
create cast (bigint as json) with function bigintJson(bigint) as implicit=
;<br />
<br />
Thanks for any guidance.<br /></div>
</div>
<div name=3D=22messageSignatureSection=22><br />
<div dir=3D=22auto=22>--<br />
Tim McLaughlin</div>
</div>
</body>
</html>

--6745b233_4f4ef005_1066--