diff options
Diffstat (limited to 'doc/src/sgml/ref/alter_function.sgml')
| -rw-r--r-- | doc/src/sgml/ref/alter_function.sgml | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index 8d9fec6005a..cdecf631b1e 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -56,8 +56,8 @@ ALTER FUNCTION <replaceable>name</replaceable> [ ( [ [ <replaceable class="param </para> <para> - You must own the function to use <command>ALTER FUNCTION</>. - To change a function's schema, you must also have <literal>CREATE</> + You must own the function to use <command>ALTER FUNCTION</command>. + To change a function's schema, you must also have <literal>CREATE</literal> privilege on the new schema. To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have <literal>CREATE</literal> privilege on @@ -86,14 +86,14 @@ ALTER FUNCTION <replaceable>name</replaceable> [ ( [ [ <replaceable class="param <listitem> <para> - The mode of an argument: <literal>IN</>, <literal>OUT</>, - <literal>INOUT</>, or <literal>VARIADIC</>. - If omitted, the default is <literal>IN</>. + The mode of an argument: <literal>IN</literal>, <literal>OUT</literal>, + <literal>INOUT</literal>, or <literal>VARIADIC</literal>. + If omitted, the default is <literal>IN</literal>. Note that <command>ALTER FUNCTION</command> does not actually pay - any attention to <literal>OUT</> arguments, since only the input + any attention to <literal>OUT</literal> arguments, since only the input arguments are needed to determine the function's identity. - So it is sufficient to list the <literal>IN</>, <literal>INOUT</>, - and <literal>VARIADIC</> arguments. + So it is sufficient to list the <literal>IN</literal>, <literal>INOUT</literal>, + and <literal>VARIADIC</literal> arguments. </para> </listitem> </varlistentry> @@ -260,8 +260,8 @@ ALTER FUNCTION <replaceable>name</replaceable> [ ( [ [ <replaceable class="param setting is removed, so that the function executes with the value present in its environment. Use <literal>RESET ALL</literal> to clear all function-local settings. - <literal>SET FROM CURRENT</> saves the value of the parameter that - is current when <command>ALTER FUNCTION</> is executed as the value + <literal>SET FROM CURRENT</literal> saves the value of the parameter that + is current when <command>ALTER FUNCTION</command> is executed as the value to be applied when the function is entered. </para> @@ -329,7 +329,7 @@ ALTER FUNCTION check_password(text) SET search_path = admin, pg_temp; </para> <para> - To disable automatic setting of <varname>search_path</> for a function: + To disable automatic setting of <varname>search_path</varname> for a function: <programlisting> ALTER FUNCTION check_password(text) RESET search_path; </programlisting> @@ -343,13 +343,13 @@ ALTER FUNCTION check_password(text) RESET search_path; <para> This statement is partially compatible with the <command>ALTER - FUNCTION</> statement in the SQL standard. The standard allows more + FUNCTION</command> statement in the SQL standard. The standard allows more properties of a function to be modified, but does not provide the ability to rename a function, make a function a security definer, attach configuration parameter values to a function, or change the owner, schema, or volatility of a function. The standard also - requires the <literal>RESTRICT</> key word, which is optional in - <productname>PostgreSQL</>. + requires the <literal>RESTRICT</literal> key word, which is optional in + <productname>PostgreSQL</productname>. </para> </refsect1> |