On Jun 21, 2006, at 18:19, Josh Berkus wrote:
Well, current case-insensitivity hacks definitely aren't compatible
with
LIKE as far as "begins with" indexes are concerned.
Yes, currently I use LOWER() for my indexes and for all LIKE, =, etc.
queries. This works well, but ORDER by of course isn't what I'd like.
That's one of the things that Elein's email domain addresses, albeit
with a USING keyword, which is unfortunate.
Of course, floating
LIKEs (%value%) are going to suck no matter what data type you're
using.
Yes, I know that. :-) I avoid that.
I created an operator for CI equality ... =~ ... which performs
well on
indexed columns. But it doesn't do "begins with".
Oops. So how could it perform well on indexed columns?
ITEXT is a TODO, but there are reasons why it's harder than it looks.
I'm sure. I should bug potential future SoC students about it. ;-)
Best,
David
