Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DROP AGGREGATE(7)	PostgreSQL 9.6.19 Documentation	     DROP AGGREGATE(7)

NAME
       DROP_AGGREGATE -	remove an aggregate function

SYNOPSIS
       DROP AGGREGATE [	IF EXISTS ] name ( aggregate_signature ) [ CASCADE | RESTRICT ]

       where aggregate_signature is:

       * |
       [ argmode ] [ argname ] argtype [ , ... ] |
       [ [ argmode ] [ argname ] argtype [ , ... ] ] ORDER BY [	argmode	] [ argname ] argtype [	, ... ]

DESCRIPTION
       DROP AGGREGATE removes an existing aggregate function. To execute this
       command the current user	must be	the owner of the aggregate function.

PARAMETERS
       IF EXISTS
	   Do not throw	an error if the	aggregate does not exist. A notice is
	   issued in this case.

       name
	   The name (optionally	schema-qualified) of an	existing aggregate
	   function.

       argmode
	   The mode of an argument: IN or VARIADIC. If omitted,	the default is
	   IN.

       argname
	   The name of an argument. Note that DROP AGGREGATE does not actually
	   pay any attention to	argument names,	since only the argument	data
	   types are needed to determine the aggregate function's identity.

       argtype
	   An input data type on which the aggregate function operates.	To
	   reference a zero-argument aggregate function, write * in place of
	   the list of argument	specifications.	To reference an	ordered-set
	   aggregate function, write ORDER BY between the direct and
	   aggregated argument specifications.

       CASCADE
	   Automatically drop objects that depend on the aggregate function
	   (such as views using	it), and in turn all objects that depend on
	   those objects (see Section 5.13, "Dependency	Tracking", in the
	   documentation).

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

NOTES
       Alternative syntaxes for	referencing ordered-set	aggregates are
       described under ALTER AGGREGATE (ALTER_AGGREGATE(7)).

EXAMPLES
       To remove the aggregate function	myavg for type integer:

	   DROP	AGGREGATE myavg(integer);

       To remove the hypothetical-set aggregate	function myrank, which takes
       an arbitrary list of ordering columns and a matching list of direct
       arguments:

	   DROP	AGGREGATE myrank(VARIADIC "any"	ORDER BY VARIADIC "any");

COMPATIBILITY
       There is	no DROP	AGGREGATE statement in the SQL standard.

SEE ALSO
       ALTER AGGREGATE (ALTER_AGGREGATE(7)), CREATE AGGREGATE
       (CREATE_AGGREGATE(7))

PostgreSQL 9.6.19		     2020		     DROP AGGREGATE(7)

NAME | SYNOPSIS | DESCRIPTION | PARAMETERS | NOTES | EXAMPLES | COMPATIBILITY | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DROP_AGGREGATE&sektion=7&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help