From: | Tino Schwarze <postgresql(at)tisc(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: order by question |
Date: | 2009-06-19 12:10:13 |
Message-ID: | 20090619121013.GC8809@easy2.in-chemnitz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, Jun 19, 2009 at 05:50:25PM +0800, Tony Liao wrote:
> Hi,All
> for example,I have a query as this
> select id,product_id from table_name where product_id in
> (6,3,4,10,7) order by .....
> the results I want to get as bellow:
> id................product_id......................
> 33...............6...................................
> 40...............6..................................
> 12...............3....................................
> 25...............4.................................
> 10...............4................................
> 17...............10.................................
> 43................7...................................
What is the exact condition, you want to order by? There's no "question"
anywhere... What is the structure of your table?
Tino.
PS: The mailing lists pgsql-novice or pgsql-general might me more
suitable for such questions.
--
"What we nourish flourishes." - "Was wir nähren erblüht."
From | Date | Subject | |
---|---|---|---|
Next Message | Sergio Gabriel Rodriguez | 2009-06-19 14:26:45 | Re: order by question |
Previous Message | Tony Liao | 2009-06-19 09:50:25 | order by question |