Re: inaccuracy in presskit 8.3

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

In response to

Responses

Browse pgsql-advocacy by date

  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