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