Index for Section AGGREGATE

Alphabetical listing for A

Bottom of page

ALTER
NAME
  ALTER AGGREGATE - change the definition of an aggregate function

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

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
  CREATE AGGREGATE [create_aggregate(5)], DROP AGGREGATE [drop_aggregate(l)]

Index for Section AGGREGATE

Alphabetical listing for A

Top of page