Re: first cut at PL/PgSQL table functions - Mailing list pgsql-patches

From Jan Wieck
Subject Re: first cut at PL/PgSQL table functions
Date
Msg-id 3D6244EF.FB8069DC@Yahoo.com
Whole thread Raw
In response to first cut at PL/PgSQL table functions  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
Neil Conway wrote:
>
> The attached patch is my first attempt at implementing table functions
> for PL/PgSQL.
> [...]
>
>         - inside PL/PgSQL, the application developer can add another
>           tuple to the result set by using RETURN NEXT. PL/PgSQL takes
>           care of creating a tuple store, etc etc.

If memory serves, the syntax another major database is using is

    RETURN ... AND RESUME;

And you're right, the parser is a nightmare. Sorry for that.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: first cut at PL/PgSQL table functions
Next
From: Jan Wieck
Date:
Subject: Re: first cut at PL/PgSQL table functions