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 )
Inputs
- name
-
The name of an existing aggregate function.
- type
-
The input data type 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
types.)
Outputs
- DROP
-
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 remove all
references to 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.