Skip site navigation (1) Skip section navigation (2)

Re: order by question

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 (view raw or flat)
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."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de

In response to

pgsql-admin by date

Next:From: Sergio Gabriel RodriguezDate: 2009-06-19 14:26:45
Subject: Re: order by question
Previous:From: Tony LiaoDate: 2009-06-19 09:50:25
Subject: order by question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group