DROP AGGREGATE -- Removes an aggregate function from a database.
Synopsis
DROP AGGREGATE nametype
Parameters
name
The name of the existing aggregate function you wish to remove.
type
The data type that the existing aggregate function accepts.
Results
DROP
The message returned when an aggregate function is dropped successfully.
ERROR: RemoveAggregate: aggregate 'name' for 'type' does not exist
The error returned if an aggregate function with the specified name and type does not exist.
Description
Use the 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.
Examples
The following example removes the sum aggregate for type text: