PL/PGSQL Newbie
От | Alan Yuill |
---|---|
Тема | PL/PGSQL Newbie |
Дата | |
Msg-id | 20010402124539.39533.qmail@web9506.mail.yahoo.com обсуждение исходный текст |
Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: