DROP AGGREGATE - Removes the definition of an aggregate
function
SYNOPSIS
DROP AGGREGATE name type
INPUTS
name The name of an existing aggregate function.
type The input datatype of an existing aggregate func
tion, or * if the function accepts any input type.
(Refer to the PostgreSQL User's Guide for further
information about data types.) [Comment: This
should become a cross-reference rather than a hard-
coded chapter number]
OUTPUTS
DROP Message returned if the command is successful.
ERROR: RemoveAggregate: aggregate 'agg' for 'type' does
not exist
This message occurs if the aggregate function spec
ified does not exist in the database.
DESCRIPTION
DROP AGGREGATE will remove all references to an existing
aggregate definition. To execute this command the current
user must be the owner of the aggregate.
NOTES
Use CREATE AGGREGATE [create_aggregate(l)] to create
aggregate functions.
USAGE
To remove the myavg aggregate for type int4:
DROP AGGREGATE myavg int4;
COMPATIBILITY
SQL92
There is no DROP AGGREGATE statement in SQL92; the state
ment is a Postgres language extension.
Man(1) output converted with
man2html