Re: Precedence of NOT LIKE, NOT BETWEEN, etc

Peter Eisentraut <peter_e@gmx.net> writes:
> On 2/23/15 3:08 PM, Tom Lane wrote:
>> I thought of another possibility:
>> 
>> 3. Leave everything as-is but mark the NOT-operator productions as having
>> the precedence of NOT rather than of LIKE etc.  This would change the
>> behavior only for the NOT-LIKE-followed-by-< example, and would make the
>> two cases for NOT LIKE consistent though they'd remain inconsistent with
>> LIKE.  This behavior seems at least somewhat explainable/documentable
>> ("NOT-foo operators have the precedence of NOT"), whereas what we have
>> seems about impossible to justify.

> I don't like this third option.  If we're going to change anything, it
> should be changed so that LIKE and NOT LIKE have the same precedence.

Yeah, I concur.  Working on patch to make that happen via token lookahead.
        regards, tom lane