Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6FD402E3F44 for ; Tue, 5 Feb 2008 17:41:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92462-04 for ; Tue, 5 Feb 2008 17:41:26 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id AA23C2E2DCC for ; Tue, 5 Feb 2008 17:41:25 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m15LeFo9028288; Tue, 5 Feb 2008 16:40:15 -0500 (EST) To: Michael Monnerie cc: pgsql-admin@postgresql.org Subject: Re: PG 8.2 change Letter Sort Order In-reply-to: <200802052222.37515@zmi.at> References: <200802052222.37515@zmi.at> Comments: In-reply-to Michael Monnerie message dated "Tue, 05 Feb 2008 22:22:33 +0100" Date: Tue, 05 Feb 2008 16:40:15 -0500 Message-ID: <28287.1202247615@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/42 X-Sequence-Number: 28116 Michael Monnerie writes: > On Dienstag, 5. Februar 2008 jkohlmeier@pronet-systeme.de wrote: >> I need a sort where ß==ss and ä ==ae. > If you find a solution, I would be interested, too. What you'd need is a locale definition that acts that way. If that is a common understanding of the meaning of sorting in German, I'd imagine someone has made one up --- but a PG list is the wrong place to be asking about it. We just use the operating system's locale facilities, we don't write our own. You'd want to find some libc or libintl hackers ... regards, tom lane