Re: Chaning locale sorting order for statements

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