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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
