VastbaseE100

ALTER ROUTINE

ALTER ROUTINE - 更改例程的定义

语法格式

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_USER | SESSION_USER }
ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
    SET SCHEMA new_schema
ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
    DEPENDS ON EXTENSION extension_name

其中action是下列之一：

    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

说明

ALTER ROUTINE更改例程的定义，该例程可以是聚合函数，正常函数或过程。有关参数说明的说明，更多示例和更多详细信息，请参阅ALTER AGGREGATE， ALTER FUNCTION和 ALTERPROCEDURE。

示例

要将 integer 类型的例程 foo 重命名为 foobar ：

ALTER ROUTINE foo(integer) RENAME TO foobar;

此命令将独立于 foo 是聚合，函数还是过程而工作。