Re: LIKE is still short some MULTIBYTE code - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: LIKE is still short some MULTIBYTE code
Date
Msg-id 20000916103655M.t-ishii@sra.co.jp
Whole thread Raw
In response to LIKE is still short some MULTIBYTE code  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Winner Notification - Linux Magazine Editor's Choice Awards (fwd))
Next
From: "Maurizio"
Date:
Subject: postgressql QNX version