Examples:

DROP FUNCTION "public"."isdate" (integer, integer, varchar, date, int)
GO
DROP FUNCTION "public"."isdate1" (integer, integer, varchar, date, int)
GO
CREATE FUNCTION "public"."isdate" (
        in a integer, 
        in "b DEFAULT name" integer default 10, 
        in c varchar default 't''est', 
        in d date default current_date,
        inout e integer default 1
    ) RETURNS integer AS 
    'select $1 + $2;' 
    LANGUAGE SQL 
    IMMUTABLE 
    RETURNS NULL ON NULL INPUT;
GO
CREATE FUNCTION "public"."isdate1" (
        in a integer, 
        in "b DEFAULT name" integer default 10, 
        in c varchar default 't''est', 
        in d date default current_date,
        inout e integer default 1
    ) RETURNS integer AS 
    'select $1 + $2;' 
    LANGUAGE SQL 
    IMMUTABLE 
    RETURNS NULL ON NULL INPUT;

Extraction and scripting has been enhanced so that the parameter default values are now supported.  This data is not in a friendly format in the catalog tables.  We are using pg_get_function_arguments(oid) to get the string value of all params with default info contained.  Will then tokenize the value and extract the default value that matches the column info and add it to the column extraction.  These default values are only scripted when the function create statement is requested and not in the drop statement.

I have back ported the code to version 17.

fixes to handle parameters without names.  fixes to handle names differing by only a blank space at end

Committed revision: 52167

should be able to handle parameters with and without names

Verified in ADS v17.0.10-10