Horton

Thread

Commits

  1. Doc: include MERGE in variable substitution command list

  1. MERGE command is not mentioned in the list of commands for variable substitution

    The Post Office <noreply@postgresql.org> — 2025-11-10T14:29:03Z

    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.

  2. Re: MERGE command is not mentioned in the list of commands for variable substitution

    David Rowley <dgrowleyml@gmail.com> — 2025-11-10T21:44:36Z

    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

  3. Re: MERGE command is not mentioned in the list of commands for variable substitution

    David Rowley <dgrowleyml@gmail.com> — 2025-11-16T21:53:49Z

    On Tue, 11 Nov 2025 at 10:44, David Rowley <dgrowleyml@gmail.com> wrote:
> The attached patch fixes it. I can take care of this once the back
> branches are open again after the minor releases are out.

Pushed.

David