MERGE command is not mentioned in the list of commands for variable substitution
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/plpgsql-implementation.html
Description:
In the last paragraph of the section 41.11.1. "Variable Substitution" there
is such a sentence --
"Variable substitution currently works only in SELECT, INSERT, UPDATE,
DELETE, and commands containing one of these..."
https://www.postgresql.org/docs/current/plpgsql-implementation.html#PLPGSQL-VAR-SUBST
But experiments showed that variable substitution works for MERGE command
too.
On Tue, 11 Nov 2025 at 05:52, PG Doc comments form
<noreply@postgresql.org> wrote:
"Variable substitution currently works only in SELECT, INSERT, UPDATE,
DELETE, and commands containing one of these..."
https://www.postgresql.org/docs/current/plpgsql-implementation.html#PLPGSQL-VAR-SUBST
But experiments showed that variable substitution works for MERGE command
too.
Thanks for the report. You're right that this has been overlooked.
The attached patch fixes it. I can take care of this once the back
branches are open again after the minor releases are out.
David