Re: return rows question

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