Yolinux.com

drop_aggregate manpage

Search topic Section
Get manual page for the search topic
List all commands matching the search topic
List all topics in the manpage index

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	  2010-12-14		      DROP AGGREGATE()
YoLinux.com Home Page
YoLinux Tutorial Index
Privacy Policy | Advertise with us | Feedback Form |
Unauthorized copying or redistribution prohibited.
    Bookmark and Share