Patch to inline stable SQL set returning UDFs

Started by Richard Rowellalmost 19 years ago2 messagespatches
Jump to latest
#1Richard Rowell
richard.rowell@gmail.com

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.

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.

--
"An eye for eye only ends up making the whole world blind." -- Mohandas Gandhi

Attachments:

inline_stable_sql_srfs-v3.patchtext/x-patch; name=inline_stable_sql_srfs-v3.patchDownload+381-0
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Richard Rowell (#1)
Re: Patch to inline stable SQL set returning UDFs

"Richard Rowell" <richard.rowell@gmail.com> 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