Re: [HACKERS] Allow use of stable functions with constraint exclusion

2007-05-08 Thread ITAGAKI Takahiro
Tom Lane <[EMAIL PROTECTED]> wrote: > "Marshall, Steve" <[EMAIL PROTECTED]> writes: > > I have developed a small patch to optimizer/util/plancat.c that > > eliminates one of hte caveats associated with constraint exclusions, > > namely the inability to avoid searching tables based on the result

Re: [HACKERS] Allow use of stable functions with constraint exclusion

2007-04-30 Thread Tom Lane
"Marshall, Steve" <[EMAIL PROTECTED]> writes: > I have developed a small patch to optimizer/util/plancat.c that > eliminates one of hte caveats associated with constraint exclusions, > namely the inability to avoid searching tables based on the results of > stable functions. Do you not understa

[HACKERS] Allow use of stable functions with constraint exclusion

2007-04-30 Thread Marshall, Steve
I have developed a small patch to optimizer/util/plancat.c that eliminates one of hte caveats associated with constraint exclusions, namely the inability to avoid searching tables based on the results of stable functions. The new code expands non-volatile functions into constant values so the