drop_aggregate

a b c d e f g h i j k l m n o p q r s t u v w x y z _
DROP AGGREGATE()		 SQL Commands		     DROP AGGREGATE()



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(7)], CREATE AGGREGATE [create_aggre-
       gate(l)]



SQL - Language Statements	  2008-01-03		     DROP AGGREGATE()