From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-alterroutine.html | 49 +++++++++++++++++++++++++++++++++ 1 file changed, 49 insertions(+) create mode 100644 doc/src/sgml/html/sql-alterroutine.html (limited to 'doc/src/sgml/html/sql-alterroutine.html') diff --git a/doc/src/sgml/html/sql-alterroutine.html b/doc/src/sgml/html/sql-alterroutine.html new file mode 100644 index 0000000..d28c780 --- /dev/null +++ b/doc/src/sgml/html/sql-alterroutine.html @@ -0,0 +1,49 @@ + +ALTER ROUTINE
ALTER ROUTINE
Prev UpSQL CommandsHome Next

ALTER ROUTINE

ALTER ROUTINE — change the definition of a routine

Synopsis

+ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
+    action [ ... ] [ RESTRICT ]
+ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
+    RENAME TO new_name
+ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
+    OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
+ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
+    SET SCHEMA new_schema
+ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
+    [ NO ] DEPENDS ON EXTENSION extension_name
+
+where action is one of:
+
+    IMMUTABLE | STABLE | VOLATILE
+    [ NOT ] LEAKPROOF
+    [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
+    PARALLEL { UNSAFE | RESTRICTED | SAFE }
+    COST execution_cost
+    ROWS result_rows
+    SET configuration_parameter { TO | = } { value | DEFAULT }
+    SET configuration_parameter FROM CURRENT
+    RESET configuration_parameter
+    RESET ALL
+

Description

+ ALTER ROUTINE changes the definition of a routine, which + can be an aggregate function, a normal function, or a procedure. See + under ALTER AGGREGATE, ALTER FUNCTION, + and ALTER PROCEDURE for the description of the + parameters, more examples, and further details. +

Examples

+ To rename the routine foo for type + integer to foobar: +

+ALTER ROUTINE foo(integer) RENAME TO foobar;
+

+ This command will work independent of whether foo is an + aggregate, function, or procedure. +

Compatibility

+ This statement is partially compatible with the ALTER + ROUTINE statement in the SQL standard. See + under ALTER FUNCTION + and ALTER PROCEDURE for more details. Allowing + routine names to refer to aggregate functions is + a PostgreSQL extension. +

See Also

ALTER AGGREGATE, ALTER FUNCTION, ALTER PROCEDURE, DROP ROUTINE

+ Note that there is no CREATE ROUTINE command. +

Prev Up Next
ALTER ROLE Home ALTER RULE
\ No newline at end of file -- cgit v1.2.3