Thread: Patch to inline stable SQL set returning UDFs
I discussed this hack with Neil and Josh in Ottawa back in May. I took a stab at it a few weeks ago and below are the results. It is mostly modeled after the existing inline_function. The approach taken is to recursively cleanup the rtable. I've been testing this in our dev environment for a few weeks now. I'm sure it still has issues but I think it is about as clean as I can get it without help from a wider audience. This is my first backend patch so please be gentle. I want to thank Neil for answering many of my supremely ignorant questions on IRC.
Attachment
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
---------------------------------------------------------------------------
richard@bowmansystems.com wrote:
> I discussed this hack with Neil and Josh in Ottawa back in May. I
> took a stab at it a few weeks ago and below are the results. It is
> mostly modeled after the existing inline_function. The approach taken
> is to recursively cleanup the rtable.
>
> I've been testing this in our dev environment for a few weeks now.
> I'm sure it still has issues but I think it is about as clean as I can
> get it without help from a wider audience. This is my first backend
> patch so please be gentle.
>
> I want to thank Neil for answering many of my supremely ignorant
> questions on IRC.
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +