Re: SRF rescan testing

Tom Lane wrote:

>>3. PL/pgSQL support for returning sets -- this seems to me like an 
>>important item if SRFs are to be useful to the masses. Any pointers on 
>>how to approach this would be appreciated.
>>
>
>Does Oracle's pl/sql support this?  If so what does it look like?
>
Oracle supports "pipelined functions". These functions use operator 
PIPE(set%rowtype)  to return a row.
Syntax for queries using pipelined functions:

SELECT f1,f2,... FROM TABLE(func(p1,p2, ...));


It seems that the most important thing to implement for PL/pgSQL 
functions returning sets is restoring of the function execution state in 
the next call


WBR, Valentine Zaretsky