Removes an aggregate function from a database.
DROP AGGREGATE name type
The name of the existing aggregate function you wish to remove.
The data type that the existing aggregate function accepts.
The message returned when an aggregate function is dropped successfully.
ERROR: RemoveAggregate: aggregate'
' for '
' does not exist
The error returned if an aggregate function with the specified name and type does not exist.
DROP AGGREGATE command to remove an aggregate function
definition from your database. As with other
DROP commands, you must be the
owner of the object that you are dropping.
The following example removes the
sum aggregate for type
booktown=# DROP AGGREGATE sum text; DROP