On Mar 20, 2013, at 1:45 AM, David E. Wheeler <david@kineticode.com> wrote:
>> Is there currently any way to create an index that can be used to speed up searches like the one above?
>> If not, do you have any idea how it might be implemented? Perhaps I could give it a try myself.
>>
>> Thank you in advance for any suggestions you might have.
>
> I would think that text_pattern_ops would work, no?
Thorbjørn replied to me privately in the negative.
Hackers, what would be required to get an index on a CITEXT column to support LIKE?
Thanks,
David