Re: Chaning locale sorting order for statements

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Albrecht Berger <berger1517(at)gmx(dot)ch>
Cc: pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Chaning locale sorting order for statements
Date: 2002-11-16 11:56:28
Message-ID: 3DD6326C.8050503@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Bartunov 2002-11-16 16:58:55 Re: Proposal of hierarchical queries, a la Oracle
Previous Message Evgen Potemkin 2002-11-16 11:30:41 Re: Proposal of hierarchical queries, a la Oracle