From: | "david williams" <dw_remote(at)hotmail(dot)com> |
---|---|
To: | <bcschnei(at)attbi(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Stored Procedures |
Date: | 2002-10-02 15:47:24 |
Message-ID: | DAV73w3q4RfEJ1XwxIM00008dcf@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
http://developer.postgresql.org/docs/postgres/xfunc-sql.html#AEN30400
See section
9.2.4. SQL Table Functions
----- Original Message -----
From: bcschnei(at)attbi(dot)com
Sent: Tuesday, October 01, 2002 4:25 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Stored Procedures
Hi all. I'm looking for a little help here. I have a
project where I have to write some stored proceedures
and am having some problems. My main issue is, I cannot
figure out how to return a record set containing
multipule columns. I am looking for a few examples on
how I can do this. Most of what I have to do is fairly
simple SQL queries based on a pramater sent to the
function. I tried to use the SETOF <datatype> option,
but only get back one column.
Any help will be would be greatly appricated. Simple
examples would be of a great help.
Thanks,
Ben
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.orgGet more from the Web. FREE MSN Explorer download : http://explorer.msn.com
From | Date | Subject | |
---|---|---|---|
Next Message | david williams | 2002-10-02 15:50:32 | Re: Stored Procedures |
Previous Message | Joe Conway | 2002-10-02 15:44:57 | Re: split function for pl/pgsql |