Re: order by question

Gary Stainburn wrote:
> Hi folks.
> 
> I seem to remember somewhere being shown how to bump specific rows to 
> the top of a list; something along the lines of:
> 
> select c_id as key, c_des as value from customers order by c_id = 7, 
> c_id = 160, value;

Looks roughly right.

SELECT * FROM foo ORDER BY not(a=6),not(a=4),a; a |  b   |  c
---+------+----- 6 | ccc  | BBB 4 | aaa  | BBB 1 | aaa  | AAA 2 | zxxx | AAA 3 | ccc  | ZZZ 5 | zxxx | BBB
(6 rows)

Alternatively: (a<>6),(a<>4),a

--  Richard Huxton  Archonet Ltd