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

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: emorgunov(at)mail(dot)ru, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: MERGE command is not mentioned in the list of commands for variable substitution
Date: 2025-11-10 21:44:36
Message-ID: CAApHDvqCWEWL3QtOr+ebCXmCu0asLTcxTVhOwBWtY_N3zx+A6w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Tue, 11 Nov 2025 at 05:52, PG Doc comments form
<noreply(at)postgresql(dot)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

Attachment Content-Type Size
v1-0001-Doc-include-MERGE-in-variable-substitution-comman.patch application/octet-stream 1.8 KB

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2025-11-11 13:12:31 Re: Use uppercase keywords in foreign key tutorial
Previous Message PG Doc comments form 2025-11-10 14:29:03 MERGE command is not mentioned in the list of commands for variable substitution