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

2005-02-08 Thread Berend Tober
> 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 As

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

2005-02-07 Thread Jonel Rienton
-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

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

2005-02-06 Thread Bruno Wolff III
On Sat, Feb 05, 2005 at 17:25:06 -0500, "Reuben D. Budiardja" <[EMAIL PROTECTED]> 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 th

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

2005-02-05 Thread Jonel Rienton
-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 So

[GENERAL] Help with sorting (ie. ORDER BY expression)

2005-02-05 Thread Reuben D. Budiardja
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 quest