Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CC8A9475921 for ; Sat, 16 Nov 2002 06:52:13 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 1824447580B for ; Sat, 16 Nov 2002 06:52:13 -0500 (EST) Received: from klaster.net (pa142.krakow.cvx.ppp.tpnet.pl [213.76.36.142]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id EAB0C2BD76; Sat, 16 Nov 2002 12:41:31 +0100 (CET) Message-ID: <3DD6326C.8050503@klaster.net> Date: Sat, 16 Nov 2002 12:56:28 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Albrecht Berger Cc: pgsql Subject: Re: Chaning locale sorting order for statements References: <018e01c28d61$cd345be0$a07ba8c0@wxp> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/235 X-Sequence-Number: 10377 Uz.ytkownik Albrecht Berger napisa?: > In Oracle I would use something like that : > SELECT * FROM table1 > ORDER BY NLSSORT(column1, 'NLS_SORT=FRENCH'); > > Does postgres has something similar ? I think, you have to create function NLSSORT by your own. C language would be nice for performance. It is possible to create operator which compares two strings, but I don't know how to tell him what the language is used now. Regards, Tomasz Myrta