diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-03-10 18:46:21 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-03-10 18:46:21 -0500 |
| commit | 678a0d286c2928aa85bcf25e5c3c633e88e44999 (patch) | |
| tree | a9606ece48cacb413ddea670773b39424cd98734 /doc/src | |
| parent | 9d4625ad0b836538618e324b4ebbc3ba366447a1 (diff) | |
| download | postgresql-678a0d286c2928aa85bcf25e5c3c633e88e44999.tar.gz postgresql-678a0d286c2928aa85bcf25e5c3c633e88e44999.zip | |
Clarify what commands are not allowed in SQL functions.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/xfunc.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index c65f8522b37..70dfe380190 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -116,9 +116,9 @@ Besides <command>SELECT</command> queries, the commands can include data modification queries (<command>INSERT</command>, <command>UPDATE</command>, and <command>DELETE</command>), as well as - other SQL commands. (The only exception is that you cannot put - <command>BEGIN</>, <command>COMMIT</>, <command>ROLLBACK</>, or - <command>SAVEPOINT</> commands into a <acronym>SQL</acronym> function.) + other SQL commands. (You cannot put transaction commands, e.g. + <command>COMMIT</>, <command>SAVEPOINT</>, and some utility + commands, e.g. <literal>VACUUM</>, into an <acronym>SQL</acronym> function.) However, the final command must be a <command>SELECT</command> or have a <literal>RETURNING</> clause that returns whatever is |