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.
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.
fixes to handle parameters without names. fixes to handle names differing by only a blank space at end
Committed revision: 52167
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
should be able to handle parameters with and without names
Issue #14859 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v18.0.0-beta-20 |
No time estimate |
Examples: