Tom Lane <[EMAIL PROTECTED]> wrote:
> ITAGAKI Takahiro <[EMAIL PROTECTED]> writes:
> > I found that the planner can deduce equality operators,
> > but cannot deduce inequality ones.
> > Are there any plans to improve handling of them?
>
> Not particularly; it doesn't seem like something that com
I wrote:
> However, it seems to be inapplicable for inequality operators. The plan
> was improved after I added the deduce-able 'U.i = 100' in theory.
Sorry, there was a miss. The correct is 'U.i < 100'.
>
> EXPLAIN SELECT * FROM T, U WHERE T.i = U.i AND T.i < 100;
>
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes:
> I found that the planner can decude equality operators,
> but cannot decude inequality ones.
> Are there any plans to improve handling of them?
Not particularly; it doesn't seem like something that comes up often
enough to be worth the work.
