Update MERGE docs to mention that ONLY is supported.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Fri, 9 Dec 2022 10:00:01 +0000 (10:00 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Fri, 9 Dec 2022 10:00:01 +0000 (10:00 +0000)
commit5defdef8aa0535b8e9365ea9cceee60d5731395f
tree90a2de2bf7262c03a745f66188fa51fea35797e3
parent07c29ca7fe30839a75d15b43c13b290a59a60ddf
Update MERGE docs to mention that ONLY is supported.

Commit 7103ebb7aa added support for MERGE, which included support for
inheritance hierarchies, but didn't document the fact that ONLY could
be specified before the source and/or target tables to exclude tables
inheriting from the tables specified.

Update merge.sgml to mention this, and while at it, add some
regression tests to cover it.

Dean Rasheed, reviewed by Nathan Bossart.

Backpatch to 15, where MERGE was added.

Discussion: https://postgr.es/m/CAEZATCU0XM-bJCvpJuVRU3UYNRqEBS6g4-zH%3Dj9Ye0caX8F6uQ%40mail.gmail.com
doc/src/sgml/ref/merge.sgml
src/test/regress/expected/merge.out
src/test/regress/sql/merge.sql