3 ms·
Looks like Postgres' RETURNING clause... The latter works with inserts and updates, too, e.g.: with foo as ( insert ... values ... returning *
by ddebernardy 13y ago
Looks like Postgres' RETURNING clause... The latter works with inserts and updates, too, e.g.:
with foo as (
insert ... values ...
returning *
),
bar as (
insert ... select ... from foo
returning *
)
select ... from foo, bar, baz ...