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

From Thomas Kellerer
Subject Re: pg_get_functiondef and overloaded functions
Date
Msg-id hcftt9$j5a$1@ger.gmane.org
Whole thread Raw
In response to Re: pg_get_functiondef and overloaded functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function Syntax Help
Next
From: Scott Marlowe
Date:
Subject: Re: Speed up UPDATE query?