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
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 poss
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');
