Re: Inequality operators are not deduced. - Mailing list pgsql-general

From ITAGAKI Takahiro
Subject Re: Inequality operators are not deduced.
Date
Msg-id 20070219095654.5B91.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
In response to Re: Inequality operators are not deduced.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.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



pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: How would you handle updating an item and related stuff all at once?
Next
From: Jeff Ross
Date:
Subject: Re: invalid regular expression: invalid backreference number