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