agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Roberto Mello <rmello@cc.usu.edu>
To: bcschnei@attbi.com
Subject: Re: Stored Procedures
Date: Tue, 1 Oct 2002 13:08:13 -0600
Message-ID: <20021001190813.GB5383@cc.usu.edu> (raw)
In-Reply-To: <20021001181701.QWQH9928.rwcrmhc52.attbi.com@rwcrwbc57>
References: <20021001181701.QWQH9928.rwcrmhc52.attbi.com@rwcrwbc57>
On Tue, Oct 01, 2002 at 06:16:57PM +0000, bcschnei@attbi.com wrote:
> 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.
In 7.2 this is acomplished through returning a cursor from the function.
See the 7.3 documentation to see how to do that (AFAIK, this is not
documented in the 7.2 docs, although it does work).
In 7.3 you can return true record sets without the use of cursors. Again,
see the docs for 7.3 in the developers site.
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
Q: How many IBM CPU's does it take to do a logical right shift?
A: 33. 1 to hold the bits and 32 to push the register.
view thread (23+ messages) latest in thread
Message-ID: <20021001190813.GB5383@cc.usu.edu>
Permalink: ../20021001190813.GB5383@cc.usu.edu/
Also on: postgresql.org/message-id/20021001190813.GB5383@cc.usu.edu
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, bcschnei@attbi.com
Subject: Re: Stored Procedures
In-Reply-To: <20021001190813.GB5383@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox