Pete <pmdwise@xxxxxxxxxxx> writes: > I am looking for an on line help with loads of examples for PSQL > specifically in regards to stored procedures or functions. > The following does not help me much. > http://www.postgresql.org/docs/8.2/interactive/sql-createfunction.html Try http://www.postgresql.org/docs/8.2/interactive/plpgsql.html particularly http://www.postgresql.org/docs/8.2/interactive/plpgsql-porting.html plpgsql tries to be like Oracle's pl/sql, but that only carries as far as the function body. The outer CREATE FUNCTION syntax is not under its control and is significantly different from Oracle's. regards, tom lane