Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> I tried
> select pg_get_functiondef('foo(int)'::regproc)
> select pg_get_functiondef('foo(int4)'::regproc)
> select pg_get_functiondef('foo(integer)'::regproc)
> but each time I get the error: function "foo(integer)" does not exist
> What am I missing?
You need to use regprocedure. regproc is mainly for bootstrap purposes
--- it accepts a function name only.
regards, tom lane