Hasn't the [HACKERS] / [GENERAL] crossover thing been resolved yet? I'm
not subscribed to hackers.
Tom Lane wrote:
>
> I finished revising the LIKE operators back into an index-optimizable
> form. But I notice there is some non-multibyte-aware code that needs
> to be fixed, specifically the pattern analysis routines in
> src/backend/utils/adt/selfuncs.c:
> like_fixed_prefix
> regex_fixed_prefix
> like_selectivity
> regex_selectivity_sub
> regex_selectivity
> I don't have time to work on this now, but perhaps someone else would
> like to fix these...
>
> regards, tom lane