Help with sorting (ie. ORDER BY expression)

From: "Reuben D(dot) Budiardja" <techlist(at)voyager(dot)phys(dot)utk(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with sorting (ie. ORDER BY expression)
Date: 2005-02-05 22:25:06
Message-ID: 200502051725.06680.techlist@voyager.phys.utk.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,
I am running postgres-7.3. I have a query like this:

SELECT question_id, question_text
FROM quiz_table
WHERE question_id IN (2,10,3,6,4,5);

But I want the output to be sorted in the way I give the question_id,
something like:

SELECT question_id, question_text
FROM quiz_table
WHERE question_id IN (2,10,3,6,4,5)
ORDER BY question_id (2,10,3,6,4,5)

Is there any way I can do that, so that the output of the query is

question_id, text
2 ...
10
3
6
4
5

Thanks for any help.

RDB

--
Reuben D. Budiardja
Dept. Physics and Astronomy
University of Tennesse, Knoxville, TN

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrey V. Semyonov 2005-02-05 22:28:53 Re: Error in trigger after upgrading to 8.0.1?
Previous Message Bjørn T Johansen 2005-02-05 20:27:30 Error in trigger after upgrading to 8.0.1?