Horton

Doc: show how to get the equivalent of LIMIT for UPDATE/DELETE.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 2daeba6a4e49f2ac4cc202fc9352c2a59e928a6c
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2024-04-07T20:26:47Z
Releases: 17.0 
Doc: show how to get the equivalent of LIMIT for UPDATE/DELETE.

Add examples showing use of a CTE and a self-join to perform
partial UPDATEs and DELETEs.

Corey Huinker, reviewed by Laurenz Albe

Discussion: https://postgr.es/m/CADkLM=caNEQsUwPWnfi2jR4ix99E0EJM_3jtcE-YjnEQC7Rssw@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/ref/delete.sgml modified +22 −2
doc/src/sgml/ref/update.sgml modified +39 −1

Documentation touched

Discussion