projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1973d9f) | patch
Doc: show how to get the equivalent of LIMIT for UPDATE/DELETE.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 7 Apr 2024 20:26:47 +0000 (16:26 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 7 Apr 2024 20:26:47 +0000 (16:26 -0400)
commit2daeba6a4e49f2ac4cc202fc9352c2a59e928a6c
tree1bfda8e54b3f7c645dd1119707fb0c24f2eee80etree
parent1973d9fb318316df16b0da89e6fe5f2c53473b38commit | diff
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
doc/src/sgml/ref/delete.sgml diff | blob | blame | history
doc/src/sgml/ref/update.sgml diff | blob | blame | history
This is the main PostgreSQL git repository.