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: | Raw Message | Whole Thread | 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 |