January 2002
Intermediate to advanced
640 pages
16h 39m
English
Removes an aggregate function from a database.
DROP AGGREGATE name typenameThe name of the existing aggregate function you wish to remove.
typeThe data type that the existing aggregate function accepts.
DROPThe message returned when an aggregate function is dropped successfully.
ERROR: RemoveAggregate: aggregate 'name' for 'type' does not existThe error returned if an aggregate function with the specified name and type does not exist.
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