NAME

ALTER FUNCTION - 修改一個(gè)函數(shù)的定義

SYNOPSIS

ALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newname

DESCRIPTION 描述

ALTER FUNCTION 修改一個(gè)函數(shù)的定義，目前***的功能是修改它的名字。  

PARAMETERS 參數(shù)

name

 一個(gè)現(xiàn)有的函數(shù)的名字（可以有模式修飾）。

type

 該函數(shù)參數(shù)的數(shù)據(jù)類型。

newname

 函數(shù)的新名字。

EXAMPLES 例子

 把名字為 sqrt，參數(shù)類型為 integer 的函數(shù)重命名為 square_root：

ALTER FUNCTION sqrt(integer) RENAME TO square_root;

COMPATIBILITY 兼容性

 在 SQL 標(biāo)準(zhǔn)里有一個(gè) ALTER FUNCTION 語句，但是它并沒有提供重命名函數(shù)的選項(xiàng)。  

SEE ALSO 參見

CREATE FUNCTION [create_function(7)], DROP FUNCTION [drop_function(l)]

#p#

NAME

ALTER FUNCTION - change the definition of a function

SYNOPSIS

ALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newname

DESCRIPTION

ALTER FUNCTION changes the definition of a function. The only functionality is to rename the function.  

PARAMETERS

name

The name (optionally schema-qualified) of an existing function.

type

The data type of an argument of the function.

newname

The new name of the function.

EXAMPLES

To rename the function sqrt for type integer to square_root:

ALTER FUNCTION sqrt(integer) RENAME TO square_root;

COMPATIBILITY

There is an ALTER FUNCTION statement in the SQL standard, but it does not provide the option to rename the function.  

SEE ALSO

CREATE FUNCTION [create_function(7)], DROP FUNCTION [drop_function(l)]