Browse categories
Random entry
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

DROP AGGREGATE

An SQL command for removing an aggregate function

DROP AGGREGATE is a DDL command for removing an aggregate function.

DROP AGGREGATE has always been present in PostgreSQL.

Change history

PostgreSQL 9.4
- support for VARIADIC aggregates added (commit 0d3f4406)
PostgreSQL 8.2
- DROP AGGREGATE IF EXISTS ... syntax added (commit bbcd0169)
- support for multiple input arguments added (commit 108fe473)
PostgreSQL 7.3
- CASCADE and RESTRICT clauses added (commit 7c6df91d)

References

PostgreSQL documentation: DROP AGGREGATE

Categories

See also

CREATE AGGREGATE, ALTER AGGREGATE