Input parameters with the same name have different types

Copy SQL

WITH params AS (SELECT 
specific_schema AS routine_schema,
regexp_replace(specific_name,'_[0-9]*$','') AS routine_name,
pg_get_function_identity_arguments(translate(substring(specific_name,'_[0-9]+$'),'_','')::int::oid) AS parameters,
parameter_name,
data_type
FROM 
information_schema.parameters
WHERE specific_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL) 
AND NOT EXISTS (SELECT 1
FROM pg_catalog.pg_depend d inner join pg_catalog.pg_proc pc ON d.objid=pc.oid
WHERE EXISTS (SELECT 1 FROM pg_catalog.pg_extension e WHERE d.refobjid=e.oid) AND
pc.proname || '_' || pc.oid = parameters.specific_name)
AND parameter_mode='IN'
AND parameter_name IS NOT NULL)
SELECT parameter_name, Count(*) AS number_of_params, Count(DISTINCT data_type) AS number_of_different_types,
string_agg(routine_schema ||'.'|| routine_name || '(' || parameters || ') ' || Upper(data_type),';<br>' ORDER BY data_type, routine_schema, routine_name) AS types
FROM params AS p
GROUP BY parameter_name
HAVING Count(DISTINCT data_type)>1
ORDER BY Count(DISTINCT data_type) DESC, Count(*) DESC, parameter_name;