> This can be easily done with pl/pgsql, visit the documentation at > http://www.postgresql.org/docs/7.3/interactive/programmer-pl.html > OT: seems like this is a questionnaire/survey application, yes? > - ----- > Jonel Rienton FWIW, given the signature: "Reuben D. Budiardja, Dept. Physics and Astronomy" he's probably trying to utilize a data base to build an inventory of test questions for the students he is responsible for actually teaching. >> 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 Your understanding of the ORDER BY clause is off. My approach would be to add a column "quiz_item_list_order", type integer, and explicity specify the rank order in which you want questions to be returned. SELECT quiz_item_list_order, question_id, question_text FROM quiz_table WHERE question_id IN (2,10,3,6,4,5) ORDER BY quiz_item_list_order; -- BMT ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
