Re: return rows question

Yeah, saw that too. Thanks for all the help.

L.
On Fri, 14 Jun 2002, Joe Conway wrote:

> Laurette Cisneros wrote:
> > Thanks. I had looked into this. But, it's not quite what I was looking
> > for.
> >
> > I am writing a set of functions to act as an api to access data in the
> > database. There are times when I would need to return a set of rows or
> > even a set of text from a pl/pgsql function based on some logic (no such
> > thing as logic in SQL).
> >
> > Any ideas?
> >
> > Thanks for the help,
> >
> > L.
>
> Sorry, but even in current development sources, PL/pgSQL cannot return a
> set (or at least if it can, I can't figure out how). I'm hoping to
> change that before 7.3 is released, but at this point I haven't even
> looked at it too hard.
>
> You might look at having your function return a refcursor. See:
> http://developer.postgresql.org/docs/postgres/plpgsql-cursors.html
> section 23.7.3.3. Returning Cursors. The URL is for the 7.3 development
> docs, but I think the example shown will work in 7.2.x.
>
> Joe
>
>
>

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Where's my....bus?