order by question - Mailing list pgsql-sql

From Gary Stainburn
Subject order by question
Date
Msg-id 200503091241.55881.gary.stainburn@ringways.co.uk
Whole thread Raw
Responses Re: order by question  (Richard Huxton <dev@archonet.com>)
Re: order by question  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: order by question  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
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;

however, although the statement is accepted the two rows specified are 
not bumped to the top of the list, but instead appear in their correct 
position in the order by value part.

Is it possible and if so how do I do it?
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     



pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Re: [ADMIN] Postgres schema comparison.
Next
From: Richard Huxton
Date:
Subject: Re: order by question