| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | pgsql-advocacy(at)postgresql(dot)org |
| Subject: | Re: inaccuracy in presskit 8.3 |
| Date: | 2007-12-02 06:44:03 |
| Message-ID: | 162867790712012244s2381e856hdf0bc3a460dd78d9@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
On 02/12/2007, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> Pavel Stehule escribió:
> > Hello
> >
> > there is
> >
> > PostgreSQL supports Table Functions. But it isn't true. This patch
> > wasn't committed.
>
> A patch based on yours was committed by Neil:
>
> 2007-07-25 00:19 neilc
>
> * doc/src/sgml/plpgsql.sgml (1.116), src/pl/plpgsql/src/gram.y
> (1.105), src/pl/plpgsql/src/pl_exec.c (1.199),
> src/pl/plpgsql/src/pl_funcs.c (1.63),
> src/pl/plpgsql/src/plpgsql.h (1.91), src/pl/plpgsql/src/scan.l
> (1.58), src/test/regress/expected/plpgsql.out (1.58),
> src/test/regress/sql/plpgsql.sql (1.49):
>
> Implement RETURN QUERY for PL/PgSQL. This provides some convenient syntax
> sugar for PL/PgSQL set-returning functions that want to return the result
> of evaluating a query; it should also be more efficient than repeated
> RETURN NEXT statements. Based on an earlier patch from Pavel Stehule.
>
Table functions are defined in standard
CREATE OR REPLACE FUNCTION blbla(params)
RETURNS TABLE(cols) AS ...
I thing, so we can use name for this feature "Return Query" and it's correct.
Pavel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2007-12-03 04:40:14 | Re: inaccuracy in presskit 8.3 |
| Previous Message | Neil Conway | 2007-12-02 03:26:30 | Re: inaccuracy in presskit 8.3 |