Re: SQL specified sort

Jeff,

If you want to receive your data in an order which
you specify manually, the easiest way to accomplish this
is to add a separate field which contains an int4 value
used by you to specify the order.

E.g.

myval | sortint
_____________________
H29 | 2
214 | 1
200 | 3
099 | 4

SELECT myval FROM mytable ORDER BY sortint;

Troy

>
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>