Browse categories
PostgreSQL releases
- PostgreSQL 15 (beta1)
- PostgreSQL 14 (latest)
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6 (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

ALTER AGGREGATE

An SQL command for modifying an aggregate function

ALTER AGGREGATE is a DDL command for modifying an aggregate function.

ALTER AGGREGATE was added in PostgreSQL 7.4.

Change history

PostgreSQL 9.5
- ALTER AGGREGATE ... OWNER TO { CURRENT_USER | SESSION_USER } syntax added (commit 31eae602)
PostgreSQL 9.4
- support for VARIADIC aggregate functions (commit 0d3f4406)
- support for ordered-set (WITHIN GROUP) aggregate functions (commit 8d65da1f)
PostgreSQL 8.2
- syntax added supporting aggregate functions with multiple input arguments (commit 108fe473)
PostgreSQL 8.1
- ALTER AGGREGATE ... SET SCHEMA ... syntax added (commit 35508d1c)
PostgreSQL 8.0
- ALTER AGGREGATE ... OWNER TO ... syntax added (commit 0adfa2c3)
PostgreSQL 7.4
- added (commit b256f242)

References

PostgreSQL documentation: ALTER AGGREGATE

Categories

See also

CREATE AGGREGATE, DROP AGGREGATE