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`

Open v_generate_udf_ddl.sql and inspect the RETURNS expression using pg_catalog.format_type(p.prorettype, NULL). Determine how the view currently obtains UDF return types and verify that the generated DDL preserves details such as character(32) and numeric(20,2).

Written by the indexing model from the issue text.