| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Erich Stamberger <eberger(at)gewi(dot)kfunigraz(dot)ac(dot)at> |
| Cc: | Moucha Václav <MouchaV(at)Radiomobil(dot)cz>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Sigh, LIKE indexing is *still* broken in foreign locales |
| Date: | 2000-06-09 07:23:08 |
| Message-ID: | 17977.960535388@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Erich Stamberger <eberger(at)gewi(dot)kfunigraz(dot)ac(dot)at> writes:
> Another interresting feature of Czech collation is:
> H < "CH" < I
Oh my, that *is* interesting (using the word in the spirit of the
ancient Chinese curse, "May you live in interesting times"...)
> So what happens with "WHERE name like 'Czec%`" ?
The wrong thing, without doubt.
Would it help any to strip off one character of the given pattern?
That is, if the pattern is LIKE 'foo%', forget about the last 'o'
and generate bounds like 'fo' <= x <= 'fp' ?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mitterwald, Holger | 2000-06-09 13:01:40 | Setting Datestyle failed |
| Previous Message | Hiroshi Inoue | 2000-06-09 02:03:11 | RE: Sigh, LIKE indexing is *still* broken in foreign locales |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB | 2000-06-09 08:09:11 | AW: Proposal: TRUNCATE TABLE table RESTRICT |
| Previous Message | Adriaan Joubert | 2000-06-09 06:00:57 | Re: Bit strings |