pg_get_functiondef and overloaded functions

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_get_functiondef and overloaded functions
Date: 2009-10-29 23:12:26
Message-ID: hcd7gq$olg$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

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?

Regards
Thomas

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2009-10-30 04:44:52 Re: pg_get_functiondef and overloaded functions
Previous Message Rob Sargent 2009-10-29 21:49:01 Re: slow count(CASE) query