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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
