Drop Aggregate
Removes an aggregate function from a database.
Synopsis
DROP AGGREGATE name type
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
:
booktown=# DROP AGGREGATE sum text;
DROP
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.