| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: SRF rescan testing |
| Date: | 2002-05-28 03:54:14 |
| Message-ID: | 1022558055.1890.4.camel@rh72.home.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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
-------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-05-28 05:00:25 | Re: revised sample SRF C function; proposed SRF API |
| Previous Message | Lamar Owen | 2002-05-28 02:18:17 | Re: Redhat 7.3 time manipulation bug |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brent Verner | 2002-05-28 03:59:08 | Re: COPY and default values |
| Previous Message | Tom Lane | 2002-05-28 02:39:04 | Re: COPY and default values |