[postgis-users] Performance Help

Mark Cave-Ayland 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 mailing list