v2025.2 LTS Stable release with long-term support v2025.1 STS Stable release with standard-term support v2024.2 LTS Stable release with long-term support v2.20 LTS Stable release with long-term support Unsupported versions

ALTER AGGREGATE

Synopsis

Use the ALTER AGGREGATE statement to change the definition of an aggregate function.

Syntax

alter_aggregate ::= ALTER AGGREGATE aggregate_name ( 
                    aggregate_signature ) alter_aggregate_action

alter_aggregate_action ::= RENAME TO new_name
                           | OWNER TO { new_owner
                                        | CURRENT_ROLE
                                        | CURRENT_USER
                                        | SESSION_USER }
                           | SET SCHEMA schema_name

aggregate_signature ::= * | aggregate_arg [ , ... ]
                        | [ aggregate_arg [ , ... ] ] ORDER BY 
                          aggregate_arg [ , ... ]

alter_aggregate

ALTERAGGREGATEaggregate_name(aggregate_signature)alter_aggregate_action

alter_aggregate_action

RENAMETOnew_nameOWNERTOnew_ownerCURRENT_ROLECURRENT_USERSESSION_USERSETSCHEMAschema_name

aggregate_signature

*,aggregate_arg,aggregate_argORDERBY,aggregate_arg

Semantics

See the semantics in the PostgreSQL documentation.

Examples

Rename an aggregate.

yugabyte=# ALTER AGGREGATE sumdouble (float8) RENAME TO other_sumdouble;

Change the owner.

yugabyte=# ALTER AGGREGATE sumdouble (float8) OWNER TO yugabyte;
yugabyte=# ALTER AGGREGATE sumdouble (float8) OWNER TO CURRENT_ROLE;
yugabyte=# ALTER AGGREGATE sumdouble (float8) OWNER TO CURRENT_USER;
yugabyte=# ALTER AGGREGATE sumdouble (float8) OWNER TO SESSION_USER;

See also