Re: Precedence of standard comparison operators - Mailing list pgsql-hackers

Noah Misch <noah@leadboat.com> writes:
> On Sun, Aug 09, 2015 at 06:44:58PM -0400, Tom Lane wrote:
>> So for our
>> purposes, it's better to keep BETWEEN and friends as binding slightly
>> tighter than '<' than to make them the same precedence.  Same precedence
>> risks breaking things that weren't broken before.

> It does risk that.  Same deal with making "=" have the same precedence as "<"
> instead of keeping it slightly lower.

Agreed, but in that case I think our hand is forced by the SQL standard.
        regards, tom lane