Re: How support more native locale in one cluster?

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