MIME-Version: 1.0
References: <0102019b608b1887-d8e9137f-46a7-4796-9f43-0addbab3c645-000000@eu-west-1.amazonses.com>
In-Reply-To: <0102019b608b1887-d8e9137f-46a7-4796-9f43-0addbab3c645-000000@eu-west-1.amazonses.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Sat, 27 Dec 2025 17:14:04 +0100
Message-ID: <CAFj8pRAKQ6qN-TkNWpFg5Gnsbkzwpo9YgnXJvUY2_GSeO1jdcA@mail.gmail.com>
Subject: Re: plpgsql: remove a field from a record?
To: "Ray O'Donnell" <ray@rodonnell.ie>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b4e6860646f14ee9"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRAKQ6qN-TkNWpFg5Gnsbkzwpo9YgnXJvUY2_GSeO1jdcA%40mail.gmail.com>
Precedence: bulk

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

Hi

so 27. 12. 2025 v 17:01 odes=C3=ADlatel Ray O'Donnell <ray@rodonnell.ie> na=
psal:

> Hi all,
>
> In a plpgsql function, is it possible to remove a field from a RECORD
> value?
>
> My specific use-case is that I have a row returned from a MERGE
> operation into a variable, declared as type RECORD, which will then be
> logged; and I want to remove some potentially sensitive stuff from it
> before it gets logged.
>
> I could manually redact the sensitive items (e.g. set them to null); but
> it'd be tidier just to remove them altogether if I can.
>
> Thanks in advance,
>

I think so it is not possible - not directly. Maybe you can use jsonb or
hstore

(2025-12-27 17:12:06) postgres=3D# create type t as (a int, b int);
(2025-12-27 17:12:24) postgres=3D# select * from
jsonb_to_record(row_to_json(row(10,20)::t)::jsonb - 'a') as (b int);
=E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=90
=E2=94=82 b  =E2=94=82
=E2=95=9E=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=A1
=E2=94=82 20 =E2=94=82
=E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=98
(1 row)

Regards

Pavel


>
> Ray.
>
> --
> Ray O'Donnell // Galway // Ireland
> ray@rodonnell.ie
>
>
>
>

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

<div dir=3D"ltr"><div>Hi</div><br><div class=3D"gmail_quote gmail_quote_con=
tainer"><div dir=3D"ltr" class=3D"gmail_attr">so 27. 12. 2025 v=C2=A017:01 =
odes=C3=ADlatel Ray O&#39;Donnell &lt;<a href=3D"mailto:ray@rodonnell.ie">r=
ay@rodonnell.ie</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex">Hi all,<br>
<br>
In a plpgsql function, is it possible to remove a field from a RECORD value=
?<br>
<br>
My specific use-case is that I have a row returned from a MERGE <br>
operation into a variable, declared as type RECORD, which will then be <br>
logged; and I want to remove some potentially sensitive stuff from it <br>
before it gets logged.<br>
<br>
I could manually redact the sensitive items (e.g. set them to null); but <b=
r>
it&#39;d be tidier just to remove them altogether if I can.<br>
<br>
Thanks in advance,<br></blockquote><div><br></div><div>I think so it is not=
 possible - not directly. Maybe you can use jsonb or hstore=C2=A0</div><div=
><br></div><div><span style=3D"font-family:monospace">(2025-12-27 17:12:06)=
 postgres=3D# create type t as (a int, b int);<br>(2025-12-27 17:12:24) pos=
tgres=3D# select * from jsonb_to_record(row_to_json(row(10,20)::t)::jsonb -=
 &#39;a&#39;) as (b int);<br>=E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=90<br>=E2=94=82 b =C2=A0=E2=94=82<br>=E2=95=9E=E2=95=90=E2=95=90=E2=
=95=90=E2=95=90=E2=95=A1<br>=E2=94=82 20 =E2=94=82<br>=E2=94=94=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=98<br>(1 row)</span><br><br></div><div>Regar=
ds</div><div><br></div><div>Pavel</div><div>=C2=A0</div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">
<br>
Ray.<br>
<br>
-- <br>
Ray O&#39;Donnell // Galway // Ireland<br>
<a href=3D"mailto:ray@rodonnell.ie" target=3D"_blank">ray@rodonnell.ie</a><=
br>
<br>
<br>
<br>
</blockquote></div></div>

--000000000000b4e6860646f14ee9--