2
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.27 2003-11-29 19:51:38 pgsql Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-DROPAGGREGATE">
8
<refentrytitle id="SQL-DROPAGGREGATE-TITLE">DROP AGGREGATE</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>DROP AGGREGATE</refname>
14
<refpurpose>remove an aggregate function</refpurpose>
17
<indexterm zone="sql-dropaggregate">
18
<primary>DROP AGGREGATE</primary>
23
DROP AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( <replaceable class="PARAMETER">type</replaceable> ) [ CASCADE | RESTRICT ]
28
<title>Description</title>
31
<command>DROP AGGREGATE</command> will delete an existing
32
aggregate function. To execute this command the current
33
user must be the owner of the aggregate function.
38
<title>Parameters</title>
42
<term><replaceable class="parameter">name</replaceable></term>
45
The name (optionally schema-qualified) of an existing aggregate function.
51
<term><replaceable class="parameter">type</replaceable></term>
54
The argument data type of the aggregate function, or
55
<literal>*</literal> if the function accepts any data type.
61
<term><literal>CASCADE</literal></term>
64
Automatically drop objects that depend on the aggregate function.
70
<term><literal>RESTRICT</literal></term>
73
Refuse to drop the aggregate function if any objects depend on
74
it. This is the default.
82
<title>Examples</title>
85
To remove the aggregate function <literal>myavg</literal> for type
88
DROP AGGREGATE myavg(integer);
94
<title>Compatibility</title>
97
There is no <command>DROP AGGREGATE</command> statement in the SQL
103
<title>See Also</title>
105
<simplelist type="inline">
106
<member><xref linkend="sql-alteraggregate" endterm="sql-alteraggregate-title"></member>
107
<member><xref linkend="sql-createaggregate" endterm="sql-createaggregate-title"></member>
113
<!-- Keep this comment at the end of the file
118
sgml-minimize-attributes:nil
119
sgml-always-quote-attributes:t
122
sgml-parent-document:nil
123
sgml-default-dtd-file:"../reference.ced"
124
sgml-exposed-tags:nil
125
sgml-local-catalogs:"/usr/lib/sgml/catalog"
126
sgml-local-ecat-files:nil