Message-ID: <0102019b60976195-55ebd253-f526-4655-9096-3817796b6803-000000@eu-west-1.amazonses.com>
Date: Sat, 27 Dec 2025 16:14:52 +0000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: plpgsql: remove a field from a record?
To: Adrian Klaver <adrian.klaver@aklaver.com>, 
	pgsql-general <pgsql-general@postgresql.org>
References: <0102019b608b1887-d8e9137f-46a7-4796-9f43-0addbab3c645-000000@eu-west-1.amazonses.com>
 <b571007a-fb84-4c6c-a86a-307d47798b7e@aklaver.com>
Content-Language: en-GB
From: Ray O'Donnell <ray@rodonnell.ie>
In-Reply-To: <b571007a-fb84-4c6c-a86a-307d47798b7e@aklaver.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Feedback-ID: ::1.eu-west-1.Bw1eu/7Uepg3xcsiFBL71JJRCh2A2yTFrgBhhiulXmU=:AmazonSES
Archived-At: <https://www.postgresql.org/message-id/0102019b60976195-55ebd253-f526-4655-9096-3817796b6803-000000%40eu-west-1.amazonses.com>
Precedence: bulk

On 27/12/2025 16:13, Adrian Klaver wrote:

> 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.


Aargh - I was being silly - of course I can return only the items I want 
to log from the MERGE.

Thanks Adrian, and apologies for the noise!

Ray.


>
>>
>> Thanks in advance,
>>
>> Ray.
>>
>
>
-- 
Ray O'Donnell // Galway // Ireland
ray@rodonnell.ie