MIME-Version: 1.0
References: <176278494385.770.15550176063450771532@wrigleys.postgresql.org>
In-Reply-To: <176278494385.770.15550176063450771532@wrigleys.postgresql.org>
From: David Rowley <dgrowleyml@gmail.com>
Date: Tue, 11 Nov 2025 10:44:36 +1300
Message-ID: 
 <CAApHDvqCWEWL3QtOr+ebCXmCu0asLTcxTVhOwBWtY_N3zx+A6w@mail.gmail.com>
Subject: Re: MERGE command is not mentioned in the list of commands for
 variable substitution
To: emorgunov@mail.ru, pgsql-docs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="000000000000cd627c06434470bc"
Archived-At: 
 <https://www.postgresql.org/message-id/CAApHDvqCWEWL3QtOr%2BebCXmCu0asLTcxTVhOwBWtY_N3zx%2BA6w%40mail.gmail.com>
Precedence: bulk

--000000000000cd627c06434470bc
Content-Type: text/plain; charset="UTF-8"

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

--000000000000cd627c06434470bc
Content-Type: application/octet-stream;
	name="v1-0001-Doc-include-MERGE-in-variable-substitution-comman.patch"
Content-Disposition: attachment;
	filename="v1-0001-Doc-include-MERGE-in-variable-substitution-comman.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mhto73b80>
X-Attachment-Id: f_mhto73b80

RnJvbSAzMTM4NTNjYzY3ZGU2NmU3NmQ1MDg1NGZiNmI1MjE4ZDQ5YzUzZmMxIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBEYXZpZCBSb3dsZXkgPGRncm93bGV5QGdtYWlsLmNvbT4KRGF0
ZTogVHVlLCAxMSBOb3YgMjAyNSAxMDozNTowNiArMTMwMApTdWJqZWN0OiBbUEFUQ0ggdjFdIERv
YzogaW5jbHVkZSBNRVJHRSBpbiB2YXJpYWJsZSBzdWJzdGl0dXRpb24gY29tbWFuZCBsaXN0CgpB
dXRob3I6IERhdmlkIFJvd2xleSA8ZGdyb3dsZXltbEBnbWFpbC5jb20+ClJlcG9ydGVkLWJ5OiBl
bW9yZ3Vub3ZAbWFpbC5ydQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE3NjI3ODQ5
NDM4NS43NzAuMTU1NTAxNzYwNjM0NTA3NzE1MzJAd3JpZ2xleXMucG9zdGdyZXNxbC5vcmcKLS0t
CiBkb2Mvc3JjL3NnbWwvcGxwZ3NxbC5zZ21sIHwgMTQgKysrKysrKy0tLS0tLS0KIDEgZmlsZSBj
aGFuZ2VkLCA3IGluc2VydGlvbnMoKyksIDcgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9j
L3NyYy9zZ21sL3BscGdzcWwuc2dtbCBiL2RvYy9zcmMvc2dtbC9wbHBnc3FsLnNnbWwKaW5kZXgg
YjU2MWI0Y2M1ODAuLjU2MWY2ZTUwZDYzIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcGxwZ3Nx
bC5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9wbHBnc3FsLnNnbWwKQEAgLTQ5NjIsMTMgKzQ5NjIs
MTMgQEAgJCQgTEFOR1VBR0UgcGxwZ3NxbDsKICAgIDxwYXJhPgogICAgIFZhcmlhYmxlIHN1YnN0
aXR1dGlvbiBjdXJyZW50bHkgd29ya3Mgb25seSBpbiA8Y29tbWFuZD5TRUxFQ1Q8L2NvbW1hbmQ+
LAogICAgIDxjb21tYW5kPklOU0VSVDwvY29tbWFuZD4sIDxjb21tYW5kPlVQREFURTwvY29tbWFu
ZD4sCi0gICAgPGNvbW1hbmQ+REVMRVRFPC9jb21tYW5kPiwgYW5kIGNvbW1hbmRzIGNvbnRhaW5p
bmcgb25lIG9mCi0gICAgdGhlc2UgKHN1Y2ggYXMgPGNvbW1hbmQ+RVhQTEFJTjwvY29tbWFuZD4g
YW5kIDxjb21tYW5kPkNSRUFURSBUQUJMRQotICAgIC4uLiBBUyBTRUxFQ1Q8L2NvbW1hbmQ+KSwK
LSAgICBiZWNhdXNlIHRoZSBtYWluIFNRTCBlbmdpbmUgYWxsb3dzIHF1ZXJ5IHBhcmFtZXRlcnMg
b25seSBpbiB0aGVzZQotICAgIGNvbW1hbmRzLiAgVG8gdXNlIGEgbm9uLWNvbnN0YW50IG5hbWUg
b3IgdmFsdWUgaW4gb3RoZXIgc3RhdGVtZW50Ci0gICAgdHlwZXMgKGdlbmVyaWNhbGx5IGNhbGxl
ZCB1dGlsaXR5IHN0YXRlbWVudHMpLCB5b3UgbXVzdCBjb25zdHJ1Y3QKLSAgICB0aGUgdXRpbGl0
eSBzdGF0ZW1lbnQgYXMgYSBzdHJpbmcgYW5kIDxjb21tYW5kPkVYRUNVVEU8L2NvbW1hbmQ+IGl0
LgorICAgIDxjb21tYW5kPkRFTEVURTwvY29tbWFuZD4sIDxjb21tYW5kPk1FUkdFPC9jb21tYW5k
PiBhbmQgY29tbWFuZHMKKyAgICBjb250YWluaW5nIG9uZSBvZiB0aGVzZSAoc3VjaCBhcyA8Y29t
bWFuZD5FWFBMQUlOPC9jb21tYW5kPiBhbmQKKyAgICA8Y29tbWFuZD5DUkVBVEUgVEFCTEUgLi4u
IEFTIFNFTEVDVDwvY29tbWFuZD4pLCBiZWNhdXNlIHRoZSBtYWluIFNRTAorICAgIGVuZ2luZSBh
bGxvd3MgcXVlcnkgcGFyYW1ldGVycyBvbmx5IGluIHRoZXNlIGNvbW1hbmRzLiAgVG8gdXNlIGEK
KyAgICBub24tY29uc3RhbnQgbmFtZSBvciB2YWx1ZSBpbiBvdGhlciBzdGF0ZW1lbnQgdHlwZXMg
KGdlbmVyaWNhbGx5IGNhbGxlZAorICAgIHV0aWxpdHkgc3RhdGVtZW50cyksIHlvdSBtdXN0IGNv
bnN0cnVjdCB0aGUgdXRpbGl0eSBzdGF0ZW1lbnQgYXMgYSBzdHJpbmcKKyAgICBhbmQgPGNvbW1h
bmQ+RVhFQ1VURTwvY29tbWFuZD4gaXQuCiAgICA8L3BhcmE+CiAKICAgPC9zZWN0Mj4KLS0gCjIu
NDAuMS53aW5kb3dzLjEKCg==
--000000000000cd627c06434470bc--