DROP_AGGREGATE(l)                               DROP_AGGREGATE(l)

NAME
       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 type of an existing aggregate function.  (Refer
              to the PostgreSQL User's Guide for further informa-
              tion 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.

       WARN 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(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.

SQL - Language Statements 15 August 1999                        1