Michal Seidl escribió: > 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 You cannot do this in existing Postgres versions without external add-ons (search for pg_strxfrm for this). There are people working on this problem; perhaps it will be possible to do it in 8.4, but there's no promise about that. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.