Search Postgresql Archives

Re: Help with sorting (ie. ORDER BY expression)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux