User-defined functions remain in the database until they are explicitly removed.
You must be the owner of the user-defined function or have one of the following system privileges:
DROP FUNCTION function-name;
The user-defined function is dropped.