PostgreSQL 8.0.1 Documentation
Prev	Fast Backward		Fast Forward	Next

DROP AGGREGATE

Name

DROP AGGREGATE -- remove an aggregate function

DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]

DROP AGGREGATE will delete an existing aggregate function. To execute this command the current user must be the owner of the aggregate function.

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.

To remove the aggregate function myavg for type integer:

DROP AGGREGATE myavg(integer);

There is no DROP AGGREGATE statement in the SQL standard.