Re: PL/PGSQL: another Q

On Fri, 17 Jan 2003, Jean-Christian Imbeault wrote:

> I've gone through the books I have and searched the web but can't find
> an answer to this question.
>
> Is it possible to have a plpgsql function return a result set (rows)? If
> so what do I declare the return type as?
>
> I know it sounds silly but the reason would be that I have these
> extremely long queries that I hate typing. I'd love to just create a
> function, do a "SELECT myfunc(1,2,3,4,5,6,7)" and have the function spew
> out the result set (rows). So far I can only find example on how to get
> PL/PGSQL to return a single value.
>
> Can this be done in PL/PGSQL?

As of 7.3 it can be done reasonably. You might want to look at the
document on set returning functions that was just put up on techdocs.