plpgsql: remove a field from a record? - Mailing list pgsql-general

From Ray O'Donnell
Subject plpgsql: remove a field from a record?
Date
Msg-id 0102019b608b1887-d8e9137f-46a7-4796-9f43-0addbab3c645-000000@eu-west-1.amazonses.com
Whole thread Raw
Responses Re: plpgsql: remove a field from a record?
Re: plpgsql: remove a field from a record?
List pgsql-general
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,

Ray.

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




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Some questions about CREATE INDEX CONCURRENTLY and pg_advisory_lock
Next
From: Adrian Klaver
Date:
Subject: Re: plpgsql: remove a field from a record?