NAME
DROP AGGREGATE - 删除一个用户定义的聚集函数
SYNOPSIS
DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]
DESCRIPTION 描述
DROP AGGREGATE 将删除一个现存聚集函数。 执行这条命令的用户必须是该聚集函数的所有者。
PARAMETERS 参数
- name
现存的聚集函数名（可以有模式修饰）。- type
聚集函数的输入数据类型，或者 * ，如果这个聚集函数接受任意输入类型。- CASCADE
自动删除依赖于这个聚集的对象。- RESTRICT
如果有任何依赖对象，则拒绝删除这个聚集。这是缺省。
EXAMPLES 例子
将类型 integer 的聚集函数 myavg 删除：
DROP AGGREGATE myavg(integer);
COMPATIBILITY 兼容性
在 SQL 标准中没有 DROP AGGREGATE 语句。
SEE ALSO 参见
ALTER AGGREGATE [alter_aggregate(7)], CREATE AGGREGATE [create_aggregate(l)]
#p#
NAME
DROP AGGREGATE - remove an aggregate function
SYNOPSIS
DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]
DESCRIPTION
DROP AGGREGATE will delete an existing aggregate function. To execute this command the current user must be the owner of 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.
- CASCADE
- Automatically drop objects that depend on the aggregate function.
- RESTRICT
- Refuse to drop the aggregate function if any objects depend on it. This is the default.
EXAMPLES
To remove the aggregate function myavg for type integer:
DROP AGGREGATE myavg(integer);
COMPATIBILITY
There is no DROP AGGREGATE statement in the SQL standard.
SEE ALSO
ALTER AGGREGATE [alter_aggregate(7)], CREATE AGGREGATE [create_aggregate(l)]
