Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > ITAGAKI Takahiro <itagaki.takahiro@xxxxxxxxxxxxx> 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
