Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8991D475921 for ; Sat, 16 Nov 2002 06:58:05 -0500 (EST) Received: from jobs1.unisoftbg.com (unknown [194.12.229.208]) by postgresql.org (Postfix) with SMTP id 54FB647580B for ; Sat, 16 Nov 2002 06:58:02 -0500 (EST) Received: (qmail 27618 invoked from network); 16 Nov 2002 13:40:16 -0000 Received: from unisoft.unisoftbg.com (HELO t1.unisoftbg.com) (194.12.229.193) by 0 with SMTP; 16 Nov 2002 13:40:16 -0000 Message-ID: <3DD625A5.32B5B4E4@t1.unisoftbg.com> Date: Sat, 16 Nov 2002 12:01:58 +0100 From: pginfo X-Mailer: Mozilla 4.03 [en] (Win95; I) MIME-Version: 1.0 To: Tomasz Myrta Cc: Albrecht Berger , pgsql Subject: Re: Chaning locale sorting order for statements References: <018e01c28d61$cd345be0$a07ba8c0@wxp> <3DD6326C.8050503@klaster.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/236 X-Sequence-Number: 10378 I am not sure about comparation performance. I have big problems with sort performance in pg by comparing varchar. Also I am not sure if it is possible to get this new funktion to replace the standart sort. regards, Ivan. Tomasz Myrta wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html