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: | Raw Message | Whole Thread | 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? |