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

From Tom Lane
Subject Re: citext operator precedence fix
Date
Msg-id 3592.1316650142@sss.pgh.pa.us
Whole thread Raw
In response to 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'd like to patch the citext contrib module for 9.2 to fix this by
> creating four new = operators to establish the comparison function for
> text and varchar.

I think you'll find that's easier said than done (problem 1 is going to
be ambiguity, and problem 2 is going to be that comparisons involving
these operators won't get indexed).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: citext operator precedence fix
Next
From: Josh Berkus
Date:
Subject: Re: citext operator precedence fix