PL/PGSQL Newbie

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

Browse pgsql-novice by date

  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?