SQL specified sort

From: "jeffrey morrison" <morrisonjeffrey(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL specified sort
Date: 2001-05-25 17:29:01
Message-ID: F51hKLcMdsokDAtTLnX00019a19@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I was wondering if you could help me out with a problem I'm having. Say for
example I have data coming out like:
H29
214
200
099

How would I use a sort to be able to make the output look like

214
H29
200
099

I don't believe their is a way to do an ORDER BY in a specific order. Any
help you could give me this problem would be very much appreciated.

Jeff Morrison
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Milen 2001-05-25 17:38:14 batch file
Previous Message Peter Eisentraut 2001-05-25 15:34:15 Re: Large Objects Documentation