Re: citext like searches using index

On 3/30/13 11:35 PM, Tom Lane wrote:
> The LIKE index optimization is hard-wired into
> match_special_index_operator(), which never heard of citext's ~~
> operators.
> 
> I've wanted for years to replace that mechanism with something that
> would support plug-in extensions, but have no very good idea how to
> do it.

I have been thinking there should be a GiST index that associates with
the pattern matching operators.  I haven't worked out the details, but
at least this seems it might be the right framework to solve this problem.