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 comes up often
Hello,
I found that the planner can decude equality operators,
but cannot decude inequality ones.
Are there any plans to improve handling of them?
I initialized tables as below.
CREATE TABLE T (i INTEGER PRIMARY KEY);
CREATE TABLE U (i INTEGER PRIMARY KEY);
INSERT INTO T SELECT
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.
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;