| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: LIKE is still short some MULTIBYTE code |
| Date: | 2000-09-16 01:36:55 |
| Message-ID: | 20000916103655M.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Weilguni | 2000-09-16 08:51:05 | Re: Patch for TNS services |
| Previous Message | The Hermit Hacker | 2000-09-16 00:29:58 | Re: Winner Notification - Linux Magazine Editor's Choice Awards (fwd)) |