Command Prompt, Inc.
DROP AGGREGATE

DROP AGGREGATE

Name

DROP AGGREGATE -- Removes an aggregate function from a database.

Synopsis

DROP AGGREGATE name type

Parameters

name

The name of the existing aggregate function you wish to remove.

type

The data type that the existing aggregate function accepts.

Results

DROP

The message returned when an aggregate function is dropped successfully.

ERROR: RemoveAggregate: aggregate 'name' for 'type' does not exist

The error returned if an aggregate function with the specified name and type does not exist.

Description

Use the DROP AGGREGATE command to remove an aggregate function definition from your database. As with other DROP commands, you must be the owner of the object that you are dropping.

Examples

The following example removes the sum aggregate for type text:

booktown=# DROP AGGREGATE sum text;
DROP

Powered by Mammoth PostgreSQL
Copyright © 2000-2007 Command Prompt, Inc. All Rights Reserved. All trademarks property of their respective owners.