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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
