ORDER BY 'criteria' - Mailing list pgsql-general

From Dennis Gearon
Subject ORDER BY 'criteria'
Date
Msg-id 1U72ZWSKFON95EBVQDA2JD7QKPIF.3e302042@cal-lab
Whole thread Raw
Responses Re: ORDER BY 'criteria'
List pgsql-general
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        Руссйя    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.



pgsql-general by date:

Previous
From: Ericson Smith
Date:
Subject: Re: PHP Abstraction Layer - Your Opinion Please
Next
From: "scott.marlowe"
Date:
Subject: Re: embedded postgres