Re: SRF rescan testing

Hannu Krosing wrote:
> On Sun, 2002-05-26 at 21:55, Joe Conway wrote:
> 
>>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?
>>
>>I *think* Oracle pl/sql can return (the equivilent of) setof composite 
>>using a special Oracle package (DBMS_OUTPUT, see: 
>>http://www.ora.com/catalog/oraclebip/chapter/ch06.html), but it cannot 
>>be used as a row source in a FROM clause. Hopefully an Oracle guru will 
>>correct or add to this.
> 
> 
> I'm no Oracle guru, but this is what a quick Google search found me:
> 
> http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89856/08_subs.htm#19677
> 

After a quick look, this appears to be a very relevant document. Does 
anyone know if this is new in 9i?

Joe