DROP AGGREGATE name type
The name of the existing aggregate function you wish to remove.
The data type that the existing aggregate function accepts.
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.
The following example removes the sum aggregate for type text:
booktown=# DROP AGGREGATE sum text; DROP