Skip to content

Commit 678a0d2

Browse files
committed
Clarify what commands are not allowed in SQL functions.
1 parent 9d4625a commit 678a0d2

File tree

1 file changed

+3
-3
lines changed

1 file changed

+3
-3
lines changed

doc/src/sgml/xfunc.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -116,9 +116,9 @@
116116
Besides <command>SELECT</command> queries, the commands can include data
117117
modification queries (<command>INSERT</command>,
118118
<command>UPDATE</command>, and <command>DELETE</command>), as well as
119-
other SQL commands. (The only exception is that you cannot put
120-
<command>BEGIN</>, <command>COMMIT</>, <command>ROLLBACK</>, or
121-
<command>SAVEPOINT</> commands into a <acronym>SQL</acronym> function.)
119+
other SQL commands. (You cannot put transaction commands, e.g.
120+
<command>COMMIT</>, <command>SAVEPOINT</>, and some utility
121+
commands, e.g. <literal>VACUUM</>, into an <acronym>SQL</acronym> function.)
122122
However, the final command
123123
must be a <command>SELECT</command> or have a <literal>RETURNING</>
124124
clause that returns whatever is

0 commit comments

Comments
 (0)