DROP  AGGREGATE  -  Removes the definition of an aggregate
       function


SYNOPSIS

       DROP AGGREGATE name type

   INPUTS
       name   The name of an existing aggregate function.

       type   The input datatype of an existing  aggregate  func­
              tion,  or * if the function accepts any input type.
              (Refer to the PostgreSQL User's Guide  for  further
              information  about  data  types.)   [Comment:  This
              should become a cross-reference rather than a hard-
              coded chapter number]

   OUTPUTS
       DROP   Message returned if the command is successful.

       ERROR: RemoveAggregate: aggregate 'agg' for 'type' does
              not exist
              This message occurs if the aggregate function spec­
              ified does not exist in the database.


DESCRIPTION

       DROP AGGREGATE will remove all references to  an  existing
       aggregate  definition. To execute this command the current
       user must be the owner of the aggregate.

   NOTES
       Use  CREATE  AGGREGATE  [create_aggregate(l)]  to   create
       aggregate functions.


USAGE

       To remove the myavg aggregate for type int4:

       DROP AGGREGATE myavg int4;


COMPATIBILITY

   SQL92
       There  is no DROP AGGREGATE statement in SQL92; the state­
       ment is a Postgres language extension.


Man(1) output converted with man2html