On Jun 21, 2005, at 5:59 PM, postgresql@xxxxxxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
