MIME-Version: 1.0
References: <536dca0f-ef1a-4621-ac1f-9c1c1dd74fbd@Spark>
In-Reply-To: <536dca0f-ef1a-4621-ac1f-9c1c1dd74fbd@Spark>
From: Victor Yegorov <vyegorov@gmail.com>
Date: Tue, 26 Nov 2024 14:36:26 +0300
Message-ID: <CAGnEbohqVqmA6gJgKmHqANMYHNtyAxv-3U3izEUVfoKoMZp-FA@mail.gmail.com>
Subject: Re: change JSON serialization for BIGINT?
To: Tim McLaughlin <tim@gotab.io>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000015c4eb0627cf43fc"
Archived-At: <https://www.postgresql.org/message-id/CAGnEbohqVqmA6gJgKmHqANMYHNtyAxv-3U3izEUVfoKoMZp-FA%40mail.gmail.com>
Precedence: bulk

--00000000000015c4eb0627cf43fc
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=D0=B2=D1=82, 26 =D0=BD=D0=BE=D1=8F=D0=B1. 2024=E2=80=AF=D0=B3. =D0=B2 14:3=
4, Tim McLaughlin <tim@gotab.io>:

> Is there a way to have Postgres serialize BIGINT as a string rather than
> number in JSON?  By default it does this:
>
>
> select row_to_json(row(500::bigint));
>  row_to_json
> -------------
>  {"f1":500}
>
> But I want it to do this (note that "500" is quoted):
>
> select row_to_json(row(500::bigint));
>  row_to_json
> -------------
>  {"f1":"500"}
>

Will this work?

select row_to_json(row(500::text));

--=20
Victor Yegorov

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

<div dir=3D"ltr"><div dir=3D"ltr">=D0=B2=D1=82, 26 =D0=BD=D0=BE=D1=8F=D0=B1=
. 2024=E2=80=AF=D0=B3. =D0=B2 14:34, Tim McLaughlin &lt;<a href=3D"mailto:t=
im@gotab.io">tim@gotab.io</a>&gt;:</div><div class=3D"gmail_quote"><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex">


<div>
<div name=3D"messageBodySection">
<div dir=3D"auto">Is there a way to have Postgres serialize BIGINT as a str=
ing rather than number in JSON?=C2=A0=C2=A0By default it does this:<br>
<br>
<br>
select row_to_json(row(500::bigint));<br>
=C2=A0row_to_json=C2=A0<br>
-------------<br>
=C2=A0{&quot;f1&quot;:500}<br>
<br>
But I want it to do this (note that &quot;500&quot; is quoted):<br>
<br>
select row_to_json(row(500::bigint));<br>
=C2=A0row_to_json=C2=A0<br>
-------------<br>
=C2=A0{&quot;f1&quot;:&quot;500&quot;}<br></div></div><div name=3D"messageS=
ignatureSection">
</div>
</div>

</blockquote></div><div><br>Will this work?<br><br>select row_to_json(row(5=
00::text));<br><br></div><span class=3D"gmail_signature_prefix">-- </span><=
br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div>Victor =
Yegorov</div></div></div></div>

--00000000000015c4eb0627cf43fc--