| From: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> |
|---|---|
| To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "PostgreSQL Development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: LIKE indexing proposal |
| Date: | 2003-05-13 09:45:21 |
| Message-ID: | 46C15C39FEB2C44BA555E356FBCD6FA4961FA8@m0114.s-mxs.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> The objection last time was that, according to the SQL standard, LIKE
> patterns should use the locale-specific collation order for the fixed
> parts (instead of character-by-character comparisons),
Yes, I think that LIKE definitely needs to be character-by-character
and I can think of no example in the german language that would make
general sense (like ss and single byte sharp s (ß) would definitely be
nonsense if handled as equal for LIKE).
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-05-13 11:40:31 | Re: Scheduled jobs |
| Previous Message | Zeugswetter Andreas SB SD | 2003-05-13 09:29:01 | Re: LIKE indexing proposal |