Re: Set locale per query?

"Rigmor Ukuhe" <rigmor(dot)ukuhe(at)finestmedia(dot)com> writes:
> Is there a way to set locale per query (i use latest JDBC drivers). I am in
> situation, where we need to make ORDER BY querys over data that is in
> various langages - English, Russian, Estonian, Latvian. I know that there
> are issues with indexing that column in such case, but what are my options
> other then sort results in my program manally.

There's no support for that in the standard backend. If you check in
the list archives, someone has posted a sorting function that takes
locale as one argument --- not sure about efficiency but it might do as
a stopgap. I believe it was last posted just a couple weeks ago in
-patches or -hackers.

regards, tom lane