pg_get_functiondef and overloaded functions - Mailing list pgsql-sql

From Thomas Kellerer
Subject pg_get_functiondef and overloaded functions
Date
Msg-id hcd7gq$olg$1@ger.gmane.org
Whole thread Raw
Responses Re: pg_get_functiondef and overloaded functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
argumentlist. 
 

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



pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: slow count(CASE) query
Next
From: Tom Lane
Date:
Subject: Re: pg_get_functiondef and overloaded functions