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.