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 (http://www.postgresql.org/docs/8.2/interactive/plperl.html). HTH, Mark. -- ILande - Open Source Consultancy http://www.ilande.co.uk _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
