order by question

Поиск
Список
Период
Сортировка
От Duncan Adams (DNS)
Тема order by question
Дата
Msg-id C54EF5B83335D311BCB50000C11042B102C8C87E@vodabemail1.vodacom.co.za
обсуждение исходный текст
Список pgsql-novice
hi all

i have a table that holds reference point for a grid
(computer room floor) the references are laid out as
following.

Horizontal         AA to EF
vertical(rows)     01 to 32

the references are stored as a single value e.g.

AA01, AA02 to EF32

Now my question, is it possible to do a query and return
the values ordered by the last two numbers (order by rows)
and if so how?

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: Problem with joins
Следующее
От: "Duncan Adams (DNS)"
Дата:
Сообщение: Re: order by question