Re: once again, sorting with Unicode - Mailing list pgsql-sql

From Tom Lane
Subject Re: once again, sorting with Unicode
Date
Msg-id 11412.1045668157@sss.pgh.pa.us
Whole thread Raw
In response to once again, sorting with Unicode  (JBJ <postgre@totw.org>)
Responses Re: once again, sorting with Unicode  ("Troy" <tjk@tksoft.com>)
List pgsql-sql
JBJ <postgre@totw.org> writes:
> Furthermore I will have to be able to switch between is_IS and others to 
> get the correct sort order ( russian sort order different from icelandic 
> for example, simply due to the nature of the letters) live when the user 
> selects a different language.

Postgres can't do that at the moment :-(.  You might be able to hack up
some custom functions to do something likeORDER BY icelandic(text_col)
but it'll be messy, and probably slow.
        regards, tom lane


pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: Default column titles in a select...
Next
From: Richard Huxton
Date:
Subject: Re: VIEW or Stored Proc - Is this even possible?