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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
