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