DROP AGGREGATE
Function
DROP AGGREGATE deletes an aggregate function.
Precautions
DROP AGGREGATE deletes an existing aggregate function. Only the owner of the aggregate function can run this command.
Syntax
DROP AGGREGATE [ IF EXISTS ] name ( argtype [ , ... ] ) [ CASCADE | RESTRICT ]
Parameter Description
IF EXISTS
Do not throw an error if the specified aggregation does not exist. A notice is issued in this case.
name
Existing aggregate function name (optionally schema-qualified).
argtype
Input data type of the aggregate function. To reference a zero-parameter aggregate function, use * to replace the input data type list.
CASCADE
Cascade deletes objects that depend on the aggregate function.
RESTRICT
Refuses to delete the aggregate function if any objects depend on it. This is a default processing.
Examples
Delete the aggregate function myavg of the integer type:
DROP AGGREGATE myavg(integer);
Compatibility
The SQL standard does not provide the DROP AGGREGATE statement.