NAME

ALTER AGGREGATE - 修改一個聚集函數的定義

SYNOPSIS

ALTER AGGREGATE name ( type ) RENAME TO newname

DESCRIPTION 描述

ALTER AGGREGATE 改變一個聚集函數的定義。目前唯一可用的功能是對聚集函數進行重命名。  

PARAMETERS 參數

name

 一個現有的聚集函數的名字（可以有模式修飾）。

type

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

newname

 聚集函數的新名字。

EXAMPLES 例子

 給一個接受 integer 類型參數的叫 myavg 的聚集函數重命名為 my_average：

ALTER AGGREGATE myavg(integer) RENAME TO my_average;

COMPATIBILITY 兼容性

 SQL 標準里面沒有 ALTER AGGREGATE 語句。  

SEE ALSO 參見

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)]