v_generate_udf_ddl.sql how can I get complete datatype of RETURN?

Hi Team,

I am currently using this DDL, It is kind of incomplete without specifying the complete return type.

right now it returns either character, date or numeric but my udf's have return as character(32) or numeric(20,2)

How can i get this details? below line is where I need to add the numbers I believe.

`RETURNS ' || pg_catalog.format_type(p.prorettype, NULL) as ddl`