This sounds like it's a "localization" issue --> aka: L18N --> ANd -- I
believe that you gave yourself the answer in your question...
It occurs to me that you should be able to GROUP BY CtryID, ORDER BY
fieldcontainingthedata;
"Dennis Gearon" <gearond@cvc.net> wrote in message
news:1U72ZWSKFON95EBVQDA2JD7QKPIF.3e302042@cal-lab...
> Scenario:
> A table that has recoreds in every language under the sun in it,
> in UTF-8 format,
> A column which identifies which language a record is in,
> An INT4 column indentifying the items which are stored in
> multiple languages.
>
> Examples:
> CtryID Country Language
> 1 Russia US-EN
> 1 � �fссйя RU <russian spelled in Russian, sort of>
>
> I want to pull out groups of records by language and the country, and then
> SORT THE RECORDS IN THE LANGUAGE SELECTED.
>
> Is there any way to say which language to ORDER BY in an SQL statement? Is
there in the SQL
> standard? If not, this is a serious deficiency for global companies.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)