On Wed, Jul 23, 2008 at 11:49:38PM +0200, Michal Seidl wrote: > Hi, I can not figure out how to solve the problem with LOCALE. Example: > - 3 tables, each of them with a text or varchar column. > - The first table with text in German > - The second table with text in Czech > - the third one with text in English > > How to force Postgre to use correct locale for ORDER BY, LIKE etc > according to language used in table? Unfortunately the answer so far is to either write it yourself or get someone to write it. PostgreSQL currently doesn't support this. Depending on your exact requirements there is some leverage to be had with judicious use and combination of cluster/database locale/encoding, text_pattern_ops, functional indexes and such matters. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
