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 |
