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