On 02/12/2007, Alvaro Herrera <alvherre@alvh.no-ip.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