Re: order by question
| От | Scott Marlowe |
|---|---|
| Тема | Re: order by question |
| Дата | |
| Msg-id | dcc563d10906191846y300dbd9cla7e965f9b478c562@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: order by question (Tony Liao <tonyliao@yuehetone.com>) |
| Ответы |
Re: order by question
|
| Список | pgsql-admin |
On Fri, Jun 19, 2009 at 7:32 PM, Tony Liao<tonyliao@yuehetone.com> wrote: > Thanks,All, > To Tino,I want to order by IN condition "(6,3,4,10,7)". > To Sergio,my answer is "Yes". > To Kenny,I think this is not the result I want to get. > To Scott,In database,there are thousands of products.the select > query is generated by application,and it is not sure how many product_id > in condition,maybe the next query would be .........product_id in > (4,26,7,8,9,23,27,54) If you generate the product_id in (4,26,7,8,9,23,27,54) part then it's pretty easy to create the order by case part too.
В списке pgsql-admin по дате отправления: