order by question

From: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
To: pgsql-novice(at)postgresql(dot)org
Subject: order by question
Date: 2002-02-05 09:38:24
Message-ID: C54EF5B83335D311BCB50000C11042B102C8C87E@vodabemail1.vodacom.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-novice by date

  From Date Subject
Next Message Duncan Adams (DNS) 2002-02-05 11:15:25 Re: order by question
Previous Message Josh Berkus 2002-02-04 22:59:12 Re: Problem with joins