order by question - Mailing list pgsql-novice

From Duncan Adams (DNS)
Subject order by question
Date
Msg-id C54EF5B83335D311BCB50000C11042B102C8C87E@vodabemail1.vodacom.co.za
Whole thread Raw
List 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 by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Problem with joins
Next
From: "Duncan Adams (DNS)"
Date:
Subject: Re: order by question