DROP AGGREGATE SQL - Language Statements DROP AGGREGATE Removes the definition of an aggregate function 1998-04-15 DROP AGGREGATE name type 1998-04-15 name The name of an existing aggregate function. type The type of an existing aggregate function. (Refer to PostgreSQL User's Guide chapter 4 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. WARN RemoveAggregate: aggregate 'name' 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 The DROP AGGREGATE statement is a PostgreSQL language extension. Refer to the CREATE AGGREGATE statement 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.