Hi,

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.

Rigmor Ukuhe

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.770 / Virus Database: 517 - Release Date: 27.09.2004


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

"Rigmor Ukuhe" <rigmor.ukuhe@finestmedia.com> writes:[color=blue]
> 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.[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org