ORDER BY 'criteria'

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема ORDER BY 'criteria'
Дата
Msg-id 1U72ZWSKFON95EBVQDA2JD7QKPIF.3e302042@cal-lab
обсуждение исходный текст
Ответы Re: ORDER BY 'criteria'  (Ian Barwick <barwick@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Ericson Smith
Дата:
Сообщение: Re: PHP Abstraction Layer - Your Opinion Please
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: embedded postgres