CREATE OR REPLACE AGGREGATE -- NOT! - Mailing list pgsql-general

I was surprised to discover that

·         CREATE OR REPLACE AGGREGATE is not allowed, but

·         CREATE OR REPLACE FUNCTION works just fine

Is this an oversight, or is there some reason I missed?

Yes, I know I can do:

DROP AGGREGATE IF EXISTS

CREATE AGGREGATE

But this triggers a NOTICE. Is there any convenient way to replace a (possibly) existing aggregate function without triggering a NOTICE?

Regards

David M Bennett FACS

Andl - A New Database Language - andl.org