top of page
CerebroSQL

PostgreSQL:  

DROP AGGREGATE

DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [ CASCADE | RESTRICT ]

where aggregate_signature is:

* |
[ argmode ] [ argname ] argtype [ , ... ] |
[ [ argmode ] [ argname ] argtype [ , ... ] ] ORDER BY [ argmode ] [ argname ] argtype [ , ... ]

Example

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

bottom of page