Thread: is it possible to return multiple rows in a PL/PGSQL function?

In pl/tcl you can return a tcl list of list as a varchar.

In plpgsql you could return a CURSOR and then you would be able to iterate
through the cursor row by row

Darren Ferguson

On Mon, 18 Feb 2002, Eric Peters wrote:

> Is it possible to return multiple rows in a PL/PGSQL function?
>
> I saw an old thread from 2000 that said no, but some "references" to 7.1/7.2's possible ability to.
> (http://postgresql.linux.cz/mhonarc/pgsql-sql/2000-08/msg00237.html)
>
> Basically can you do a setof in a pl/pgsql function (or even pl/perl?) or am I just dreaming? :)
>
> Thanks,
>
> Eric
>