DROP AGGREGATE SQL - Language Statements DROP AGGREGATE Removes the definition of an aggregate function 1999-07-20 DROP AGGREGATE name type 1998-04-15 name The name of an existing aggregate function. type The input datatype of an existing aggregate function, or * if the function accepts any input type. (Refer to the PostgreSQL User's Guide for further information about data types.) This should become a cross-reference rather than a hard-coded chapter number 1998-04-15 DROP Message returned if the command is successful. ERROR: RemoveAggregate: aggregate 'agg' for 'type' does not exist This message occurs if the aggregate function specified does not exist in the database. 1998-04-15 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. 1998-04-15 Use to create aggregate functions. To remove the myavg aggregate for type int4: DROP AGGREGATE myavg int4; 1998-04-15 There is no DROP AGGREGATE statement in SQL92; the statement is a Postgres language extension.