| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | postgresql(at)bryden(dot)co(dot)za |
| Cc: | "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Scripting issues |
| Date: | 2005-06-21 09:15:10 |
| Message-ID: | ACFC727E-8133-49CE-84D6-26B33323EDA7@myrealbox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jun 21, 2005, at 5:59 PM, postgresql(at)bryden(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yuri Gordienko | 2005-06-21 09:19:43 | HELP!!! Corrupt Database! |
| Previous Message | postgresql | 2005-06-21 08:59:58 | Re: Scripting issues |