Re: [SQL] Chaning locale sorting order for statements

[Tomasz Myrta]

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