Re: citext like searches using index

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Thorbjørn Weidemann <thorbjoern(at)weidemann(dot)name>
Cc: "pgsql-hackers(at)postgresql(dot)org Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: citext like searches using index
Date: 2013-03-29 19:12:28
Message-ID: 34421250-7777-46F4-B704-DAC63523A2C7@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mar 20, 2013, at 1:45 AM, David E. Wheeler <david(at)kineticode(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2013-03-29 19:12:40 Re: [COMMITTERS] pgsql: Add parallel pg_dump option.
Previous Message Jim Nasby 2013-03-29 18:37:22 Re: Enabling Checksums