Re: options for no multiple rows?

"pgsql" <pgsqllist(at)mail(dot)rineco(dot)com> wrote in message
news:Pine(dot)LNX(dot)4(dot)21(dot)0201262203530(dot)25983-100000(at)mail(dot)rineco(dot)com(dot)(dot)(dot)
> Greets!
>
> Ok, from what I've read (good, bad or indifferent) you can't create a
> stored procedure/function and return multiple rows to use in say a
> resultset with the following:
>

I've been searching for a solution to this problem too. Until now I've used
MSSQL where multiple rows (or even multiple resultsets) are't any problem
inside a sp.

I've thought about it and came up with the following idea.
NOTE: I haven't tested this!!!!!

Create a temporay table with the resultset you want.
Fill the table inside the sp
Do a select on the temporay table.

I don't now if it will work, but it looks okay.

regards
Yvo