Josh Berkus writes:
> After having some production issues, I did some testing and it seems
> that any SQL function declared STRICT will never inline.
It won't unless the planner can prove that the resulting expression
behaves the same, ie, is also strict for *all* the parameters. Which
in most c
On Tuesday, November 08, 2011 15:29:03 Josh Berkus wrote:
> Folks,
>
> After having some production issues, I did some testing and it seems
> that any SQL function declared STRICT will never inline. As a result,
> it won't work with either indexes (on the underlying predicate) or
> partitioning.
Folks,
After having some production issues, I did some testing and it seems
that any SQL function declared STRICT will never inline. As a result,
it won't work with either indexes (on the underlying predicate) or
partitioning.
This seems like a horrible gotcha for our users. At the very least I
