/usr/man2/cat.l/drop_aggregate.l.Z(/usr/man2/cat.l/drop_aggregate.l.Z)

NAME

       DROP AGGREGATE - remove an aggregate function

SYNOPSIS

       DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]

DESCRIPTION

       DROP  AGGREGATE  will delete an existing aggregate function. To execute
       this command the current user must be the owner of the aggregate  func-
       tion.

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.

       CASCADE
              Automatically  drop  objects  that depend on the aggregate func-
              tion.

       RESTRICT
              Refuse to drop the aggregate function if any objects  depend  on
              it. This is the default.

EXAMPLES

       To remove the aggregate function myavg for type integer:

       DROP AGGREGATE myavg(integer);

COMPATIBILITY

       There is no DROP AGGREGATE statement in the SQL standard.

SEE ALSO

       ALTER  AGGREGATE  [alter_aggregate(l)], CREATE AGGREGATE [create_aggre-
       gate(l)]

SQL - Language Statements         2005-11-05                  DROP AGGREGATE()