From 678a0d286c2928aa85bcf25e5c3c633e88e44999 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 10 Mar 2011 18:46:21 -0500 Subject: [PATCH] Clarify what commands are not allowed in SQL functions. --- doc/src/sgml/xfunc.sgml | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index c65f8522b3..70dfe38019 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -116,9 +116,9 @@ Besides SELECT queries, the commands can include data modification queries (INSERT, UPDATE, and DELETE), as well as - other SQL commands. (The only exception is that you cannot put - BEGIN, COMMIT, ROLLBACK, or - SAVEPOINT commands into a SQL function.) + other SQL commands. (You cannot put transaction commands, e.g. + COMMIT, SAVEPOINT, and some utility + commands, e.g. VACUUM, into an SQL function.) However, the final command must be a SELECT or have a RETURNING clause that returns whatever is -- 2.49.0