ALTER AGGREGATE () manpage
DESCRIPTION
ALTER AGGREGATE changes the definition of an
aggregate function.
PARAMETERS
- 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.
EXAMPLES
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;
COMPATIBILITY
There is no ALTER AGGREGATE statement in the SQL
standard.
SEE ALSO
