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

 

Reply via email to