Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 68B8C475921 for ; Sat, 16 Nov 2002 06:16:28 -0500 (EST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 3599347580B for ; Sat, 16 Nov 2002 06:16:26 -0500 (EST) Received: (qmail 12610 invoked by uid 0); 16 Nov 2002 11:16:27 -0000 Received: from pd9e0d804.dip.t-dialin.net (HELO wxp) (217.224.216.4) by mail.gmx.net (mp018-rz3) with SMTP; 16 Nov 2002 11:16:27 -0000 Message-ID: <018e01c28d61$cd345be0$a07ba8c0@wxp> From: "Albrecht Berger" To: "pgsql" Subject: Chaning locale sorting order for statements Date: Sat, 16 Nov 2002 11:51:28 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/234 X-Sequence-Number: 10376 Hello, is it possible to change the locale sorting order in statements ? I need this for a multilingual web application, where I'm not able to set the locale in the session or elsewhere. In Oracle I would use something like that : SELECT * FROM table1 ORDER BY NLSSORT(column1, 'NLS_SORT=FRENCH'); Does postgres has something similar ? Thx berger