Re: ORDER BY 'criteria'

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(at)cvc(dot)net> wrote in message
news:1U72ZWSKFON95EBVQDA2JD7QKPIF(dot)3e302042(at)cal-lab(dot)(dot)(dot)
> 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(at)postgresql(dot)org)