drop_aggregate(7)

NAME#

DROP_AGGREGATE - remove an aggregate function

SYNOPSIS#

DROP AGGREGATE [ IF EXISTS ] \nname\n ( \naggregate_signature\n ) [, ...] [ CASCADE | RESTRICT ]
where \naggregate_signature\n is:
* |
[ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ] |
[ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ] ] ORDER BY [ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ]

DESCRIPTION#

DROP AGGREGATE removes an existing aggregate function. To execute this command the current user must be the owner of the aggregate function.

PARAMETERS#

IF EXISTS

name

argmode

argname

argtype

CASCADE

RESTRICT

NOTES#

Alternative syntaxes for referencing ordered-set aggregates are described under ALTER AGGREGATE (ALTER_AGGREGATE(7)).

EXAMPLES#

To remove the aggregate function myavg for type integer:

DROP AGGREGATE myavg(integer);

To remove the hypothetical-set aggregate function myrank, which takes an arbitrary list of ordering columns and a matching list of direct arguments:

DROP AGGREGATE myrank(VARIADIC "any" ORDER BY VARIADIC "any");

To remove multiple aggregate functions in one command:

DROP AGGREGATE myavg(integer), myavg(bigint);

COMPATIBILITY#

There is no DROP AGGREGATE statement in the SQL standard.

SEE ALSO#

ALTER AGGREGATE (ALTER_AGGREGATE(7)), CREATE AGGREGATE (CREATE_AGGREGATE(7))