Re: Inequality operators are not deduced.

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> 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
> enough to be worth the work.

Hmm... Then I'll add redundant conditions to where-clause manually
in such cases. However, it occured in an actual application ported
from another database to postgres. I'll try to improve the handling
and tell you if it will come good.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center