Morris de Oryx <morrisdeoryx(at)gmail(dot)com> writes:
> For what it's worth, the citext_pattern_ops option seems to provide
> case-blind = searches, which text_pattern_ops does not. Unless I got
> confused when I tested out the various permutations. If that's true, then
> citext_pattern_ops has value for me.
The default citext index opclass should handle that case fine ...
regards, tom lane