This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
DROP
AGGREGATE
Name
DROP AGGREGATE -- remove a user-defined
aggregate function
Synopsis
DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]
Inputs
- name
-
The name (optionally schema-qualified) of an existing
aggregate function.
- type
-
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
types.)
- CASCADE
-
Automatically drop objects that depend on the
aggregate.
- RESTRICT
-
Refuse to drop the aggregate if there are any
dependent objects. This is the default.
Outputs
- DROP AGGREGATE
-
Message returned if the command is successful.
- ERROR: RemoveAggregate:
aggregate 'name' for type
type does not
exist
-
This message occurs if the aggregate function
specified does not exist in the database.
Description
DROP AGGREGATE will delete an
existing aggregate definition. To execute this command the
current user must be the owner of the aggregate.
Usage
To remove the myavg aggregate for
type int4:
DROP AGGREGATE myavg(int4);
Compatibility
SQL92
There is no DROP AGGREGATE
statement in SQL92; the
statement is a PostgreSQL
language extension.