Re: Chaning locale sorting order for statements

Поиск
Список
Период
Сортировка
От Tomasz Myrta
Тема Re: Chaning locale sorting order for statements
Дата
Msg-id 3DD6326C.8050503@klaster.net
обсуждение исходный текст
Ответ на Chaning locale sorting order for statements  ("Albrecht Berger" <berger1517@gmx.ch>)
Список 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 по дате отправления:

Предыдущее
От: "Albrecht Berger"
Дата:
Сообщение: Chaning locale sorting order for statements
Следующее
От: pginfo
Дата:
Сообщение: Re: Chaning locale sorting order for statements