DROP AGGREGATE

Description

Drops an aggregate function.

Precautions

DROP AGGREGATE deletes an existing aggregate function. Only the owner of the aggregate function can run this command.

Syntax

DROP AGGREGATE [ IF EXISTS ] name ( argtype [ , ... ] ) [ CASCADE | RESTRICT ];

Parameters

• IF EXISTS

  If the specified aggregate function does not exist, a NOTICE prompt is generated, but no error is generated.

• name

  Name of an existing aggregate function (optionally schema-qualified).

• argtype

  Input data type of the aggregate function. To reference a zero-parameter aggregate function, replace the input data type list using *.

• CASCADE

  Cascade deletes objects that depend on the aggregate function.

• RESTRICT

  Refuses to delete the aggregate function if any objects depend on it. This is a default processing.

Examples

-- Create a user-defined function.
gaussdb=# CREATE OR REPLACE FUNCTION int_add(int,int)
	RETURNS int AS $BODY$
DECLARE
BEGIN
	RETURN $1 + $2;
END;
$BODY$ language plpgsql;

-- Create an aggregate function.
gaussdb=# CREATE AGGREGATE myavg (int)
(
    sfunc = int_add,
    stype = int,
    initcond = '0'
);

-- Drop the aggregate function myavg of the int type.
gaussdb=# DROP AGGREGATE myavg(int);

-- Drop the user-defined function.
gaussdb=# DROP FUNCTION int_add(int,int);

Helpful Links

ALTER AGGREGATE and CREATE AGGREGATE

Compatibility

The SQL standard does not provide the DROP AGGREGATE statement.