Обсуждение: RETURNING to_jsonb(...)
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(*);
Thanks in advance
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.klaver@aklaver.com