pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
UPDATE mentions the RETURNING * syntax but does not mention RETURNING * INTO ... 2+ messages / 2 participants [nested] [flat]
* UPDATE mentions the RETURNING * syntax but does not mention RETURNING * INTO ... @ 2023-09-04 15:55 James Stuart <slim2k@privatejuris.org> 0 siblings, 1 reply; 2+ messages in thread From: James Stuart @ 2023-09-04 15:55 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org 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./ ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: UPDATE mentions the RETURNING * syntax but does not mention RETURNING * INTO ... @ 2023-09-04 21:00 Tom Lane <tgl@sss.pgh.pa.us> parent: James Stuart <slim2k@privatejuris.org> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2023-09-04 21:00 UTC (permalink / raw) To: James Stuart <slim2k@privatejuris.org>; +Cc: pgsql-bugs@lists.postgresql.org James Stuart <slim2k@privatejuris.org> writes: > UPDATE mentions the RETURNING * syntax but does not mention RETURNING * > INTO ... > https://www.postgresql.org/docs/15/sql-update.html 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-09-04 21:00 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-09-04 15:55 UPDATE mentions the RETURNING * syntax but does not mention RETURNING * INTO ... James Stuart <slim2k@privatejuris.org> 2023-09-04 21:00 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox