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
>