"pgsql" <pgsqllist@mail.rineco.com> wrote in message
news:Pine.LNX.4.21.0201262203530.25983-100000@mail.rineco.com...
> 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