Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_get_functiondef and overloaded functions - Mailing list pgsql-sql

From Tom Lane
Subject Re: pg_get_functiondef and overloaded functions
Date
Msg-id 1311.1256877892@sss.pgh.pa.us
Whole thread Raw
In response to pg_get_functiondef and overloaded functions  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: pg_get_functiondef and overloaded functions  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-sql
Tree view 
Thomas Kellerer <spam_eater@gmx.net> 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 regprocedure.  regproc is mainly for bootstrap purposes
--- it accepts a function name only.
        regards, tom lane

pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: pg_get_functiondef and overloaded functions
Next
From: Richard Huxton
Date:
Subject: Re: slow count(CASE) query