Re: Sigh, LIKE indexing is *still* broken in foreign locales - Mailing list pgsql-hackers

From Roland Roberts
Subject Re: Sigh, LIKE indexing is *still* broken in foreign locales
Date
Msg-id m266riyi4f.fsf@tycho.rlent.pnet
Whole thread Raw
In response to Re: Sigh, LIKE indexing is *still* broken in foreign locales  (Erich Stamberger <eberger@gewi.kfunigraz.ac.at>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
   Tom> Erich Stamberger <eberger@gewi.kfunigraz.ac.at> writes:   >> Another interresting feature of Czech collation
is:H < "CH" < I
 
   >> So what happens with "WHERE name like 'Czec%`" ?
   Tom> The wrong thing, without doubt.

I think this is a conceptual problem: some languages use more than one
character to designate a single "letter" in their orthography.  Even
more "familiar" languagues such as Spanish do this: ch, ll, rr.  Maybe
they've changed since I was taught, but my Spanish dictionaries are
put "ciudad" before "chico" (in fact, the latter is in a separate
section after "C" and before "D").

Sorry if this doesn't help find a solution, though....

roland
- --            PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                    Unix Software Solutions
roberts@panix.com                      76-15 113th Street, Apt 3B
rbroberts@acm.org                          Forest Hills, NY 11375

-----BEGIN PGP SIGNATURE-----
Version: 2.6.3a
Charset: noconv
Comment: Processed by Mailcrypt 3.5.4, an Emacs/PGP interface

iQCVAwUBOUEQFOoW38lmvDvNAQED5wQAnwW1BpbCeghJWXh/gTMezRfDfLq2eSPu
4+H0X6Xjm2Gbegrv1SiWlSCjD1yR/FYIgTQpbMCubXlAtadu5tc4auLGNsOdSNIC
3lT2Bc+En5BxT06dsX33QApU1B4GP73KFxSJu2+ngRMKExTFEojM7qzLlKfGzDeG
onaP+RPbtJc=
=Dlnw
-----END PGP SIGNATURE-----


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE DROP COLUMN
Next
From: Bruce Momjian
Date:
Subject: Re: xlog.c.patch for cygwin port.