Name
DROP AGGREGATE
-- Removes the definition of an aggregate function from the database.
Synopsis
DROP AGGREGATE name type
Parameters
- name
This parameter takes the name of the existing aggregate function you wish to remove.
- type
This parameter takes the type of the existing aggregate function you wish to remove.
Results
- DROP
This message is displayed if the aggregate function is dropped successfully.
- ERROR RemoveAggregate: aggregate 'agg' for 'type' does not exist
This error message is displayed if an aggregate function with name
specified does not exist in the database.
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 aggregate to use this
command.
Examples
Use the following example to remove the myavg aggregate for type int4.
DROP AGGREGATE myavg int4;