JBJ <postgre(at)totw(dot)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 like
ORDER BY icelandic(text_col)
but it'll be messy, and probably slow.
regards, tom lane