2. Is there any performance or other advantage to using PL/pgsql over
Pl/Perl or Python?
Yes, if you want to loop over large amounts of data (FOR row IN SELECT)
plpgsql will be faster since it does not have to convert the data from
postgres to python/perl format.
---
On May 29, 2007, at 10:30 , Michael Glaesemann wrote:
You can take a look in the pg_proc table, which is part of the
system catalog, to see which functions are installed.
file:///usr/local/pgsql/pgsql-8.2.0/doc/html/catalog-pg-proc.html
Ha! That link won't be very helpful, will it :)
This
Robert James wrote:
1. How can I get a list of available functions (ie, user defined or
contrib)
using SQL?
To see how PG does it:
psql -E
\df
2. Is there any performance or other advantage to using PL/pgsql over
Pl/Perl or Python?
1. It's more likely to be available (not relevant if y
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.
file:///usr/local/pgsql/pgsql-8.2.0/
1. How can I get a list of available functions (ie, user defined or contrib)
using SQL?
2. Is there any performance or other advantage to using PL/pgsql over
Pl/Perl or Python?
