X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6CDEE475458 for ; Wed, 19 Feb 2003 10:22:34 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id A76A5475425 for ; Wed, 19 Feb 2003 10:22:33 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1JFMb5u011413; Wed, 19 Feb 2003 10:22:37 -0500 (EST) To: JBJ Cc: pgsql-sql@postgresql.org Subject: Re: once again, sorting with Unicode In-reply-to: <5.1.0.14.0.20030218224724.02705ff8@localhost> References: <5.1.0.14.0.20030218224724.02705ff8@localhost> Comments: In-reply-to JBJ message dated "Tue, 18 Feb 2003 23:13:04 +0000" Date: Wed, 19 Feb 2003 10:22:37 -0500 Message-ID: <11412.1045668157@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/430 X-Sequence-Number: 11828 JBJ writes: > Furthermore I will have to be able to switch between is_IS and others to > get the correct sort order ( russian sort order different from icelandic > for example, simply due to the nature of the letters) live when the user > selects a different language. Postgres can't do that at the moment :-(. You might be able to hack up some custom functions to do something like ORDER BY icelandic(text_col) but it'll be messy, and probably slow. regards, tom lane