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

Fri, 15 Sep 2000 16:06:47 -0400
Tom Lane <tgl@sss.pgh.pa.us>
LIKE is still short some MULTIBYTE code
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

Fri, 15 Sep 2000 16:26:38 -0400
Joseph Shraibman <jks@selectacast.net>
Re: LIKE is still short some MULTIBYTE code
> 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...

I have taken a glance on them. Seems no special multibyte hack is
neccesary for them. Also, though limited to small scale data, SELECT
using index on multibyte data seems to be working...
--
Tatsuo Ishii

Sat, 16 Sep 2000 10:36:55 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: LIKE is still short some MULTIBYTE code