Re: BUG #14437: BTREE Index is not used for queries on citext columns

pawel(dot)kania(at)moneyhouse(dot)de writes:
> [ citext LIKE operator isn't indexable ]

Yeah. Don't hold your breath waiting for that to get better :-(.
The problem is that there's no way for extensions to plug into the
"special index operator" mechanism in the planner, so there's no
way to derive indexable range conditions from the citext LIKE operator.
That's probably solvable with enough sweat, but so far no one has
taken an interest in working on it.

Even if that were fixed, I'm not sure that your examples would be
indexable, because the patterns all start with case-foldable characters.
The "special index operator" conversion for ILIKE just throws up its hands
when it sees that, and I doubt citext could do any better.

regards, tom lane