On May 29, 2007, at 9:49 , Robert James wrote:
> 1. How can I get a list of available functions (ie, user defined or
> contrib) using SQL?
You can take a look in the pg_proc table, which is part of the system
catalog, to see which functions are installed.
You might try something like
NATURAL JOIN (
SELECT oid as prolang, lanname
FROM pg_language) AS lang
ORDER BY proname, pronargs, lanname;
proname | pronargs | lanname
RI_FKey_cascade_del | 0 | internal
RI_FKey_cascade_upd | 0 | internal
RI_FKey_check_ins | 0 | internal
RI_FKey_check_upd | 0 | internal
> 2. Is there any performance or other advantage to using PL/pgsql
> over Pl/Perl or Python?
It depends on what your function is doing. If you're doing simple SQL-
type things, PL/pgsql might be a good fit. If you're doing more
advanced text processing or calling external libraries, PL/Perl could
be better. I don't have any experience with Python.
As with all things, test and benchmark to for your particular case
for the best results :)
Hope this helps.
grzm seespotcode net
In response to
pgsql-general by date
|Next:||From: Richard Huxton||Date: 2007-05-29 15:34:51|
|Subject: Re: Languages and Functions|
|Previous:||From: A. Kretschmer||Date: 2007-05-29 15:18:19|
|Subject: Re: Will a DELETE violate an FK?|