Documentation → PostgreSQL 8.0

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4

Historical version. PostgreSQL 8.0 reached end of support in October 2010. See the current version for supported releases.

PostgreSQL 8.0.26 Documentation
Prev	Fast Backward		Fast Forward	Next

ALTER AGGREGATE

Name

ALTER AGGREGATE -- change the definition of an aggregate function

ALTER AGGREGATE name ( type ) RENAME TO newname
ALTER AGGREGATE name ( type ) OWNER TO newowner

ALTER AGGREGATE changes the definition of an aggregate function.

name: The name (optionally schema-qualified) of an existing aggregate function.
type: The argument data type of the aggregate function, or * if the function accepts any data type.
newname: The new name of the aggregate function.
newowner: The new owner of the aggregate function. You must be a superuser to change an aggregate's owner.

To rename the aggregate function myavg for type integer to my_average:

ALTER AGGREGATE myavg(integer) RENAME TO my_average;

To change the owner of the aggregate function myavg for type integer to joe:

ALTER AGGREGATE myavg(integer) OWNER TO joe;

There is no ALTER AGGREGATE statement in the SQL standard.

Read the upstream documentation. For corrections, first check the current version.

Prev	Home	Next
ABORT	Up	ALTER CONVERSION