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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: show how to get the equivalent of LIMIT for UPDATE/DELETE.
Date: 2024-04-07 20:26:54
Message-ID: E1rtZ6M-0011B9-0A@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2daeba6a4e49f2ac4cc202fc9352c2a59e928a6c

Modified Files
--------------
doc/src/sgml/ref/delete.sgml | 24 ++++++++++++++++++++++--
doc/src/sgml/ref/update.sgml | 40 +++++++++++++++++++++++++++++++++++++++-
2 files changed, 61 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2024-04-07 21:08:22 pgsql: Remove useless duplicate call of defGetBoolean().
Previous Message Tom Lane 2024-04-07 19:36:26 pgsql: Doc: update documentation about EXCLUDE constraint elements.