Re: first cut at PL/PgSQL table functions

From: Neil Conway <neilc(at)samurai(dot)com>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: first cut at PL/PgSQL table functions
Date: 2002-08-19 20:16:38
Message-ID: 87y9b2zjrt.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Neil Conway <neilc(at)samurai(dot)com> writes:
> The attached patch is my first attempt at implementing table functions
> for PL/PgSQL.

Oh, one more thing: the patch also includes a minor cleanup to the
FunctionMode enum, which I discussed with Joe Conway via private
email. The "use a tuple store provided by the function" mechanism is a
bit of a hack right now, but Joe and I discussed making it more
general (adding another FunctionMode for it, and allowing it to be
specified when executing CREATE FUNCTION). That will wait for 7.4,
however.

I also removed some spi.c functions that were just wrappers over the
appropriate "regular" postgres functions (e.g. SPI_pfree), and
replaced them with macros. IMHO that communicates the intent more
clearly.

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2002-08-19 20:42:35 functions-matching correct?
Previous Message Neil Conway 2002-08-19 20:03:49 first cut at PL/PgSQL table functions