Re: first cut at PL/PgSQL table functions

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(at)Yahoo(dot)com #