[postgis-users] Performance Help
mark.cave-ayland at ilande.co.uk
Thu Jul 26 07:10:20 PDT 2007
On Thu, 2007-07-26 at 13:52 +0000, Alan Cunnane wrote:
> By stored procedures what do you mean exactly? Do you mean in a Perl
> script or something similar?
Nearly. The advantage of stored procedures is that they are a type of
function that executes on the server. They are typically used for SQL
statements, however you can also do interesting things like FOR loops
and IF statements.
The main language for stored procedures is PL/PGSQL
(http://www.postgresql.org/docs/8.2/interactive/plpgsql.html), but if
you're more familiar with Perl, you'll probably find PL/Perl easier to
get along with
ILande - Open Source Consultancy
More information about the postgis-users