UPDATE mentions the RETURNING * syntax but does not mention RETURNING * INTO ...
UPDATE mentions the RETURNING * syntax but does not mention RETURNING *
INTO ...
https://www.postgresql.org/docs/15/sql-update.html
--
*— James Stuart*
/This private communication and any attachment(s) are protected by the
expectation of privacy and is for the sole use of the intended recipient
and contains privileged and/or confidential information. No monitoring
of my communication or other means of surveillance, electronic and
otherwise, is permitted and I reserve all my rights, without recourse
and without prejudice, nunc pro tunc. I do not consent to anyone
tampering with, altering, monitoring or delaying any incoming or
outgoing communication./
James Stuart <slim2k@privatejuris.org> writes:
UPDATE mentions the RETURNING * syntax but does not mention RETURNING *
INTO ...
That's because there is no such thing so far as the core SQL parser is
concerned (so if you try it from, say, psql, it won't work).
There is such syntax in plpgsql, and that's where it's documented:
https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW
regards, tom lane