Re: plpgsql: remove a field from a record?
| От | Pavel Stehule |
|---|---|
| Тема | Re: plpgsql: remove a field from a record? |
| Дата | |
| Msg-id | CAFj8pRAKQ6qN-TkNWpFg5Gnsbkzwpo9YgnXJvUY2_GSeO1jdcA@mail.gmail.com обсуждение исходный текст |
| Ответ на | plpgsql: remove a field from a record? (Ray O'Donnell <ray@rodonnell.ie>) |
| Список | pgsql-general |
Hi
so 27. 12. 2025 v 17:01 odesílatel Ray O'Donnell <ray@rodonnell.ie> napsal:
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=# create type t as (a int, b int);
(2025-12-27 17:12:24) postgres=# select * from jsonb_to_record(row_to_json(row(10,20)::t)::jsonb - 'a') as (b int);
┌────┐
│ b │
╞════╡
│ 20 │
└────┘
(1 row)
(2025-12-27 17:12:24) postgres=# select * from jsonb_to_record(row_to_json(row(10,20)::t)::jsonb - 'a') as (b int);
┌────┐
│ b │
╞════╡
│ 20 │
└────┘
(1 row)
Regards
Pavel
Ray.
--
Ray O'Donnell // Galway // Ireland
ray@rodonnell.ie
В списке pgsql-general по дате отправления: