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 regpro
Thomas Kellerer 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
Hi,
I'm playing around with the new pg_get_functiondef() function but I can't get it to work when I need to specify the argument list.
select pg_get_functiondef('foo'::regproc)
works without problems.
However if I have e.g. foo(int) and foo(int, int) I can't get this to work.
I tried
s
