-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, 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 http://blogs.road14.com Software Developer, *nix Advocate On Feb 5, 2005, at 4:25 PM, Reuben D. Budiardja wrote: > > 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly > -----BEGIN PGP SIGNATURE----- Version: PGP 8.1 iQA/AwUBQgVKluAwOVAnbsGCEQIc4ACfXgnHExJ7MnYzp419Sq1g7mCkErMAniW3 xqKCBaSCrpX2JDm5cHnpnOy4 =52vz -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
