Re: RETURNING to_jsonb(...)

On 5/5/20 1:11 PM, Miles Elam wrote:
> How can the new record returned from RETURNING to converted to jsonb?
>
> For example something like:
>
> INSERT INTO my_table (a, b, c) VALUES ('a', 'b', 'c')
> RETURNING to_jsonb(*);
>
>
> or
>
> UPDATE my_table SET a = 'a'
> RETURNING to_jsonb(*);
>
>
> or
>
> INSERT INTO my_table (a, b, c) VALUES ('a', 'b', 'c')
>
> ON CONFLICT DO UPDATE SET a = EXCLUDED.a
>
> RETURNING to_jsonb(*);
>
>

insert into sample_tbl values(3, 2) returning to_jsonb(sample_tbl.*);
to_jsonb
-----------------------------------
{"sample_id": 3, "freezer_fk": 2}
(1 row)

>
> Thanks in advance

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