Tom Lane wrote on 14.08.2014 17:33:
Leave out the OUT parameters altogether:
select pg_get_functiondef('public.foo(text, text)'::regprocedure);
Only IN parameters contribute to the function's identity; OUT parameters
are just a variant method of specifying its return type.
Ah, great. I didn't
Thomas Kellerer writes:
> Hello,
> pg_get_functiondef() can be used quite easily by using a cast to
> regprocedure, like this:
> select pg_get_functiondef('public.foo(text, text, text)'::regprocedure);
> However if the function is defined with an out parameter like this:
> create or re
Hello,
pg_get_functiondef() can be used quite easily by using a cast to regprocedure,
like this:
select pg_get_functiondef('public.foo(text, text, text)'::regprocedure);
However if the function is defined with an out parameter like this:
create or replace function foo(p1 text, p2 out te