From e7889b83b7059e776f0a3d76bbbdd98687f4592c Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 3 Sep 2007 18:46:30 +0000 Subject: Support SET FROM CURRENT in CREATE/ALTER FUNCTION, ALTER DATABASE, ALTER ROLE. (Actually, it works as a plain statement too, but I didn't document that because it seems a bit useless.) Unify VariableResetStmt with VariableSetStmt, and clean up some ancient cruft in the representation of same. --- doc/src/sgml/ref/alter_function.sgml | 14 +++++++++----- 1 file changed, 9 insertions(+), 5 deletions(-) (limited to 'doc/src/sgml/ref/alter_function.sgml') diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index 964603b067a..bee2f6f4390 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -1,5 +1,5 @@ @@ -21,7 +21,7 @@ PostgreSQL documentation ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) - action [, ... ] [ RESTRICT ] + action [ ... ] [ RESTRICT ] ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) RENAME TO new_name ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) @@ -36,8 +36,10 @@ where action is one of: [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER COST execution_cost ROWS result_rows - SET parameter { TO | = } { value | DEFAULT } - RESET parameter + SET configuration_parameter { TO | = } { value | DEFAULT } + SET configuration_parameter FROM CURRENT + RESET configuration_parameter + RESET ALL @@ -215,7 +217,7 @@ where action is one of: - parameter + configuration_parameter value @@ -226,6 +228,8 @@ where action is one of: setting is removed, so that the function executes with the value present in its environment. Use RESET ALL to clear all function-local settings. + SET FROM CURRENT saves the session's current value of + the parameter as the value to be applied when the function is entered. -- cgit v1.2.3