Skip to content

Commit 5d5b05c

Browse files
committed
Doc: include MERGE in variable substitution command list
Backpatch to 15, where MERGE was introduced. Reported-by: <emorgunov@mail.ru> Author: David Rowley <dgrowleyml@gmail.com> Discussion: https://postgr.es/m/176278494385.770.15550176063450771532@wrigleys.postgresql.org Backpatch-through: 15
1 parent d61af52 commit 5d5b05c

File tree

1 file changed

+7
-7
lines changed

1 file changed

+7
-7
lines changed

doc/src/sgml/plpgsql.sgml

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -4897,13 +4897,13 @@ $$ LANGUAGE plpgsql;
48974897
<para>
48984898
Variable substitution currently works only in <command>SELECT</command>,
48994899
<command>INSERT</command>, <command>UPDATE</command>,
4900-
<command>DELETE</command>, and commands containing one of
4901-
these (such as <command>EXPLAIN</command> and <command>CREATE TABLE
4902-
... AS SELECT</command>),
4903-
because the main SQL engine allows query parameters only in these
4904-
commands. To use a non-constant name or value in other statement
4905-
types (generically called utility statements), you must construct
4906-
the utility statement as a string and <command>EXECUTE</command> it.
4900+
<command>DELETE</command>, <command>MERGE</command> and commands
4901+
containing one of these (such as <command>EXPLAIN</command> and
4902+
<command>CREATE TABLE ... AS SELECT</command>), because the main SQL
4903+
engine allows query parameters only in these commands. To use a
4904+
non-constant name or value in other statement types (generically called
4905+
utility statements), you must construct the utility statement as a string
4906+
and <command>EXECUTE</command> it.
49074907
</para>
49084908

49094909
</sect2>

0 commit comments

Comments
 (0)