Re: Precedence of NOT LIKE, NOT BETWEEN, etc

Peter Eisentraut <peter_e(at)gmx(dot)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