1DROP AGGREGATE()                 SQL Commands                 DROP AGGREGATE()
2
3
4

NAME

6       DROP AGGREGATE - remove an aggregate function
7
8

SYNOPSIS

10       DROP AGGREGATE [ IF EXISTS ] name ( type [ , ... ] ) [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

14       DROP  AGGREGATE  will delete an existing aggregate function. To execute
15       this command the current user must be the owner of the aggregate  func‐
16       tion.
17

PARAMETERS

19       IF EXISTS
20              Do  not throw an error if the aggregate does not exist. A notice
21              is issued in this case.
22
23       name   The name (optionally schema-qualified) of an existing  aggregate
24              function.
25
26       type   An input data type on which the aggregate function operates.  To
27              reference a zero-argument aggregate function, write *  in  place
28              of the list of input data types.
29
30       CASCADE
31              Automatically  drop  objects  that depend on the aggregate func‐
32              tion.
33
34       RESTRICT
35              Refuse to drop the aggregate function if any objects  depend  on
36              it. This is the default.
37

EXAMPLES

39       To remove the aggregate function myavg for type integer:
40
41       DROP AGGREGATE myavg(integer);
42
43

COMPATIBILITY

45       There is no DROP AGGREGATE statement in the SQL standard.
46

SEE ALSO

48       ALTER  AGGREGATE  [alter_aggregate(7)], CREATE AGGREGATE [create_aggre‐
49       gate(l)]
50
51
52
53SQL - Language Statements         2008-06-08                  DROP AGGREGATE()