| From: | Alan Yuill <alanyuill(at)yahoo(dot)co(dot)uk> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | PL/PGSQL Newbie |
| Date: | 2001-04-02 12:45:39 |
| Message-ID: | 20010402124539.39533.qmail@web9506.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lars Forseth | 2001-04-02 17:14:53 | Postgres 7.0.3 and ODBC |
| Previous Message | Lars Forseth | 2001-04-02 07:42:03 | has anybody got ODBC working under SusE 7.0 and postgres 7.03? |