Tom Lane wrote on 30.10.2009 05:44:
>> 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.
>
Thanks, works fine.
Where would I find a documentation of all those types?
The section about pg_get_functiondef (and others) doesn't mention this.
Regards
Thomas