The named aggregate is a system-defined aggregate. You can overload the functions that support the built-in aggregates, but you cannot redefine or drop built-in aggregates.
Create support functions for the named aggregate but do not use the CREATE AGGREGATE statement.