Re: pg_get_functiondef and overloaded functions

Поиск
Список
Период
Сортировка
Искать
От
Thomas Kellerer
Тема
Re: pg_get_functiondef and overloaded functions
Дата
Msg-id
hcftt9$j5a$1@ger.gmane.org
Ответ на
Список
Дерево обсуждения
pg_get_functiondef and overloaded functions Thomas Kellerer <spam_eater@gmx.net>
Re: pg_get_functiondef and overloaded functions Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_get_functiondef and overloaded functions Thomas Kellerer <spam_eater@gmx.net>
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 по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: Function Syntax Help
От: Scott Marlowe
Дата:
Сообщение: Re: Speed up UPDATE query?
FAQ