Re: [PATCHES] Patch to inline stable SQL set returning UDFs

[Tom Lane]

"Richard Rowell" <[EMAIL PROTECTED]> writes:
> 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 where stable SQL functions are
> found in it.

Applied with revisions --- the recursion issue wasn't being managed
properly, and there were some other problems ...

regards, tom lane

-- 
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches

Re: [PATCHES] Patch to inline stable SQL set returning UDFs

[Bruce Momjian]

This has been saved for the 8.4 release:

http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---

[EMAIL PROTECTED] 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  <[EMAIL PROTECTED]>http://momjian.us
  EnterpriseDB http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match