SQL specified sort - Mailing list pgsql-sql

From jeffrey morrison
Subject SQL specified sort
Date
Msg-id F51hKLcMdsokDAtTLnX00019a19@hotmail.com
Whole thread Raw
Responses Re: SQL specified sort
List 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.



pgsql-sql by date:

Previous
From: Linh Luong
Date:
Subject: Select for LEFT JOIN
Next
From: D0
Date:
Subject: Triggers in 7.0.x and SQL syntax.