This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
version, or one of the supported versions listed above instead.
DROP AGGREGATE -- Removes the definition
of an aggregate function
DROP AGGREGATE name type
The name of an existing aggregate function.
The input datatype of an existing aggregate function,
or * if the function accepts any
input type. (Refer to the PostgreSQL
User's Guide for further information about data
Message returned if the command is successful.
- ERROR: RemoveAggregate:
aggregate 'agg' for
'name' does not
This message occurs if the aggregate function
specified does not exist in the database.
DROP AGGREGATE will remove all
references to an existing aggregate definition. To execute this
command the current user must be the owner of the aggregate.
To remove the myavg aggregate for
DROP AGGREGATE myavg int4;
There is no DROP AGGREGATE statement
in SQL92; the statement is a