Provided by: postgresql-client-8.0_8.0.7-2build1_i386 bug

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