From: | Valentine Zaretsky <valik(at)apex(dot)dp(dot)ua> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Joe Conway <mail(at)joeconway(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: SRF rescan testing |
Date: | 2002-05-28 12:48:52 |
Message-ID: | 3CF37CB4.8010900@apex.dp.ua |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joel Burton | 2002-05-28 13:09:04 | Re: wierd AND condition evaluation for plpgsql |
Previous Message | Olivier PRENANT | 2002-05-28 12:28:13 | Re: WAL FILES |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-28 14:50:48 | Re: revised sample SRF C function; proposed SRF API |
Previous Message | Joe Conway | 2002-05-28 06:15:00 | Re: SRF rescan testing |