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

From Albrecht Berger
Subject Chaning locale sorting order for statements
Date
Msg-id 018e01c28d61$cd345be0$a07ba8c0@wxp
Whole thread Raw
List pgsql-sql
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');

Does postgres has something similar ?

Thx
berger


pgsql-sql by date:

Previous
From: "Peter T. Brown"
Date:
Subject: how can I improve the speed of this query
Next
From: Tomasz Myrta
Date:
Subject: Re: Chaning locale sorting order for statements