NAME

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

SYNOPSIS

ALTER AGGREGATE name ( type ) RENAME TO newname

DESCRIPTION 描述

ALTER AGGREGATE 改變一個(gè)聚集函數(shù)的定義。目前唯一可用的功能是對(duì)聚集函數(shù)進(jìn)行重命名。  

PARAMETERS 參數(shù)

name

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

type

 聚集函數(shù)的參數(shù)數(shù)據(jù)類型，如果函數(shù)接受任何數(shù)據(jù)類型，則是 *。

newname

 聚集函數(shù)的新名字。

EXAMPLES 例子

 給一個(gè)接受 integer 類型參數(shù)的叫 myavg 的聚集函數(shù)重命名為 my_average：

ALTER AGGREGATE myavg(integer) RENAME TO my_average;

COMPATIBILITY 兼容性

 SQL 標(biāo)準(zhǔn)里面沒(méi)有 ALTER AGGREGATE 語(yǔ)句。  

SEE ALSO 參見(jiàn)

CREATE AGGREGATE [create_aggregate(7)], DROP AGGREGATE [drop_aggregate(l)]

#p#

NAME

ALTER AGGREGATE - change the definition of an aggregate function

SYNOPSIS

ALTER AGGREGATE name ( type ) RENAME TO newname

DESCRIPTION

ALTER AGGREGATE changes the definition of an aggregate function. The only currently available functionality is to rename the aggregate function.  

PARAMETERS

name

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

type

The argument data type of the aggregate function, or * if the function accepts any data type.

newname

The new name of the aggregate function.

EXAMPLES

To rename the aggregate function myavg for type integer to my_average:

ALTER AGGREGATE myavg(integer) RENAME TO my_average;

COMPATIBILITY

There is no ALTER AGGREGATE statement in the SQL standard.  

SEE ALSO

CREATE AGGREGATE [create_aggregate(7)], DROP AGGREGATE [drop_aggregate(l)]