[postgis-users] creating custom function using PL/PgSQL

Jan Hartmann j.l.h.hartmann at uva.nl
Wed Sep 22 03:29:30 PDT 2004


Eduardo Patto Kanegae wrote:

> Hi Folks,
> 
> sorry this little off-topic question, but could someone suggest me some 
> reference link to how to create custom functions using PL/PgSQL...
> 
> I mean: I wanna create a fuction to use as : " SELECT FIELD1, FIELD2, 
> MyFunction(Field3 ) FROM MYTABLE "
> 
> best
> 

Hi Eduardo,

The Pl/PgSQL documentation is at:

http://www.postgresql.org/docs/7.4/static/plpgsql.html

It has enough examples to get you going.

Jan



More information about the postgis-users mailing list