云数据库 GAUSSDB-ALTER FUNCTION:语法格式

时间:2024-07-01 18:37:09

语法格式

  • 修改自定义函数的附加参数。
    1
    2
    ALTER FUNCTION function_name ( [ { [ argname ] [ argmode ] argtype} [, ...] ] )
        action [ ... ] [ RESTRICT ];
    

    其中附加参数action子句语法为:

     1
     2
     3
     4
     5
     6
     7
     8
     9
    10
    11
    {CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT}
     | {IMMUTABLE | STABLE | VOLATILE}
     | {SHIPPABLE | NOT SHIPPABLE}
     | {NOT FENCED | FENCED}
     | [ NOT ] LEAKPROOF
     | { [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER }
     | AUTHID { DEFINER | CURRENT_USER }
     | COST execution_cost
     | ROWS result_rows
     | SET configuration_parameter { { TO | = } { value | DEFAULT }| FROM CURRENT}
     | RESET {configuration_parameter | ALL}
    
  • 修改自定义函数的名称。
    1
    2
    ALTER FUNCTION function_name ( [ { [ argname ] [ argmode ] argtype} [, ...] ] )
        RENAME TO new_name;
    
  • 修改自定义函数的所有者。
    1
    2
    ALTER FUNCTION function_name ( [ { [ argname ] [ argmode ] argtype} [, ...] ] )
        OWNER TO new_owner;
    
  • 修改自定义函数的模式。
    1
    2
    ALTER FUNCTION function_name ( [ { [ argname ] [ argmode ] argtype} [, ...] ] )
        SET SCHEMA new_schema;
    
support.huaweicloud.com/distributed-devg-v8-gaussdb/gaussdb-12-0488.html