Re: plpgsql: remove a field from a record?

On 12/27/25 08:01, Ray O'Donnell wrote:
> 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.

A record 'type' supports record_name.field_name notation. Not sure how
many fields you want to log, but you could log only the non-sensitive
fields explicitly e.g. record_name.fld1, record_name.fld3,
record_name.fld4, etc.

>
> Thanks in advance,
>
> Ray.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com