On Fri, Jun 19, 2009 at 3:50 AM, Tony Liao<tonyliao@xxxxxxxxxxxxx> 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................................... > any Idea? thanks I take it you want the set sorted by product_id order of 6,3,4,10 ??? order by case when product_id = 6 then 1 when product_id=3 then 2 when product_id=4 then 3 when product_id=10 then 4 else product_id+1000 end; -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
