Postgres Pro
Downloads
Home   >   mailing lists

Re: citext like searches using index - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: citext like searches using index
Date
Msg-id 34421250-7777-46F4-B704-DAC63523A2C7@kineticode.com
Whole thread Raw
In response to Re: citext like searches using index  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: citext like searches using index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pkg-config files for libpq and ecpg
Next
From: Tom Lane
Date:
Subject: Re: citext like searches using index