This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
version, or one of the other supported versions listed above instead.
DROP AGGREGATE -- remove a user-defined
DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]
The name (optionally schema-qualified) of an existing
The input data type of the aggregate function, or
* if the function accepts any
input type. (Refer to the PostgreSQL
User's Guide for further information about data
Automatically drop objects that depend on the
Refuse to drop the aggregate if there are any
dependent objects. This is the default.
- DROP AGGREGATE
Message returned if the command is successful.
- ERROR: RemoveAggregate:
aggregate 'name' for type
type does not
This message occurs if the aggregate function
specified does not exist in the database.
DROP AGGREGATE will delete 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 PostgreSQL