pgsql: doc: Improve a couple of places in the MERGE docs. - Mailing list pgsql-committers

From Dean Rasheed
Subject pgsql: doc: Improve a couple of places in the MERGE docs.
Date
Msg-id E1rkOU9-003bX7-CM@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
doc: Improve a couple of places in the MERGE docs.

In the synopsis, make the syntax for merge_update consistent with the
syntax for a plain UPDATE command. It was missing the optional "ROW"
keyword that can be used in a multi-column assignment, and the option
to assign from a multi-column subquery, both of which have been
supported by MERGE since it was introduced.

In the parameters section for the with_query parameter, mention that
WITH RECURSIVE isn't supported, since this is different from plain
INSERT, UPDATE, and DELETE commands. While at it, move that entry to
the top of the list, for consistency with the other pages.

Back-patch to v15, where MERGE was introduced.

Discussion: https://postgr.es/m/CAEZATCWoQyWkMFfu7JXXQr8dA6%3DgxjhYzgpuBP2oz0QoJTxGWw%40mail.gmail.com

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/a875743ff40226f4096140efc506bd909da2a21f

Modified Files
--------------
doc/src/sgml/ref/merge.sgml | 36 ++++++++++++++++++++++++++++--------
1 file changed, 28 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: meson: macos: Avoid warnings on Sonoma
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Make the order of the header file includes consistent