plpgsql: remove a field from a record?

Поиск
Список
Период
Сортировка
От Ray O'Donnell
Тема plpgsql: remove a field from a record?
Дата
Msg-id 0102019b608b1887-d8e9137f-46a7-4796-9f43-0addbab3c645-000000@eu-west-1.amazonses.com
обсуждение исходный текст
Ответы Re: plpgsql: remove a field from a record?
Re: plpgsql: remove a field from a record?
Список 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 по дате отправления: