Re: SQL Order Question

You might be able to achieve what you want using the fact that Order By
sorts false before true, so:

    Order By not(contractid = 'BTS'), contractid ASC

Regards,
George

----- Original Message -----
From: <operationsengineer1@yahoo.com>
To: <pgsql-novice@postgresql.org>
Sent: Thursday, May 04, 2006 1:33 PM
Subject: [NOVICE] SQL Order Question


> hi all,
>
> i want to order contract numbers id ascending order,
> with the exception of 'BTS' that I want to display
> first.  the contract numbers are numeric and 'BTS' is
> text.  the numeric values come first when i sort in
> asc order - as expected.  how can i get BTS (id = 0)
> to come up as the first value in my query?
>
> tia...
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>