I am trying to get some development experience with PostgreSQL. I am
have created a set of tables and now want to write some generic
create/retrieve database procedures to allow various languages to
insert and retrieve records.
Seems simple enough, however I can't figure out how to return multiple
columns (or full table records) from a PL/PGSQL function? Returning
one column is OK using the RETURN <type> clause, but how do you return
a row from a table? Also how do you return multiple records from a
table?
Is there a good PL/pgSQL referenece manual online that can answer these
and other questions?
Any help appreciated.
=====
--------------------------------
Do not underestimate the power
of the Penguin!
--------------------------------
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie