Re: Scripting issues

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Scripting issues
Дата
Msg-id ACFC727E-8133-49CE-84D6-26B33323EDA7@myrealbox.com
обсуждение исходный текст
Ответ на Re: Scripting issues  (postgresql@bryden.co.za)
Список pgsql-general
On Jun 21, 2005, at 5:59 PM, postgresql@bryden.co.za wrote:

> One other question: Since in PostgreSQL you can have "overloaded"
> functions, how do you query the system tables for the existence of a
> particular version of the function?

The pg_proc table (which contains the functions) includes a field
that has an argument list array. You can use this to figure out which
if the one you want to drop exists.

http://www.postgresql.org/docs/8.0/interactive/catalog-pg-proc.html

Michael Glaesemann
grzm myrealbox com


В списке pgsql-general по дате отправления:

Предыдущее
От: postgresql@bryden.co.za
Дата:
Сообщение: Re: Scripting issues
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: renumber id's in correct order (compact id's)