Re: Chaning locale sorting order for statements - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Chaning locale sorting order for statements
Date
Msg-id 3DD6326C.8050503@klaster.net
Whole thread Raw
In response to Chaning locale sorting order for statements  ("Albrecht Berger" <berger1517@gmx.ch>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: "Albrecht Berger"
Date:
Subject: Chaning locale sorting order for statements
Next
From: pginfo
Date:
Subject: Re: Chaning locale sorting order for statements