I'm using 1.16 beta 4 on Windows (the version that comes with EDB PostgreSQL
9.2RC1)
When I do this:
CREATE OR REPLACE FUNCTION test_defaults(param_int integer, param_def text
DEFAULT NULL::text) RETURNS text AS
$$
SELECT $2;
$$
language sql;
Then right click or look in code paid to see the function created, it shows
this:
CREATE OR REPLACE FUNCTION public.test_defaults(param_int integer, param_def
text) RETURNS text AS
$BODY$
SELECT $2;
$BODY$ LANGUAGE sql VOLATILE COST 100;
As a result I can' reuse it becauseit says default parameters can't be
changed.
Thanks,
Regina