CREATE OR REPLACE AGGREGATE -- NOT!

From: "dandl" <david(at)andl(dot)org>
To:
Cc: "'Postgres General'" <pgsql-general(at)postgresql(dot)org>
Subject: CREATE OR REPLACE AGGREGATE -- NOT!
Date: 2016-05-05 01:47:59
Message-ID: 009601d1a670$28ffb650$7aff22f0$@andl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2016-05-05 02:40:40 Re: Debian and Postgres
Previous Message dandl 2016-05-05 01:16:27 Re: Thoughts on "Love Your Database"