From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: HISTORY updated, 7.3 branded |
Date: | 2002-09-04 19:01:39 |
Message-ID: | 200209041901.g84J1d301944@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > I don't remember every seeing a function returning sets before. Can you
> > give an example?
>
> http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/xfunc-sql.html#AEN26392
>
> Also, the preceding subsection shows SQL functions returning rows. So
> these features have been there, but they were messy and awkward to use.
> Recall that the TODO item was
> * -Functions returning sets do not totally work
> and not "we don't have functions returning sets".
Yes, now I remember, only SQL functions could return sets. How about
this:
PL/PgSQL and C functions can now return sets, with multiple
rows and multiple columns. You specify these functions in the
SELECT FROM clause, similar to a table or view.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-04 19:13:18 | Re: HISTORY updated, 7.3 branded |
Previous Message | Tom Lane | 2002-09-04 18:51:37 | Re: HISTORY updated, 7.3 branded |