Re: citext operator precedence fix - Mailing list pgsql-hackers

From Tom Lane
Subject Re: citext operator precedence fix
Date
Msg-id 5378.1316652178@sss.pgh.pa.us
Whole thread Raw
In response to Re: citext operator precedence fix  (Josh Berkus <josh@agliodbs.com>)
Responses Re: citext operator precedence fix
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> I think you'll find that's easier said than done (problem 1 is going to
>> be ambiguity, 

> Ambiguity?

Yeah, I'm worried about the possibility of parser failing to resolve
which operator is meant.

>> and problem 2 is going to be that comparisons involving
>> these operators won't get indexed).

> Yeah, that's acceptable, since it's not any worse than the behavior of
> the comparisons now.

No, I don't think so.  For people for whom the right thing is happening,
you'll risk making it (a) wrong and (b) lots slower.  For people for
whom the wrong thing is happening, maybe you'll fix it so it's
semantically right, but if indexes don't work they still won't be happy.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: Range Types - typo + NULL string constructor
Next
From: Josh Berkus
Date:
Subject: Re: citext operator precedence fix