Re: [GENERAL] ORDER BY FIELD feature

[Guillaume Lelarge]

Kevin Reynolds a écrit :
Does postgresql have something similar to the ORDER BY FIELD feature 
found in MySQL?
 
Something like ORDER BY FIELD(ID, 10, 2, 56, 40);
 
It is listed here:  http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html
 
I am using the Sphinx Search program, www.sphinxsearch.com 
, and it returns a list of IDs ordered by 
relevance.  I take the array it gives me and create a comma separated 
list which is used in a postgres query using the WHERE "ID" IN (10, 2, 
56, 40) statement.  I would like to order the result by the order of the 
list.
 


ORDER BY ID=10 DESC, ID=2 DESC, ID=56 DESC, ID=40  DESC
is the only way, AFAIK.

Regards.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] ORDER BY FIELD feature

[Kevin Reynolds]

Does postgresql have something similar to the ORDER BY FIELD feature found in 
MySQL?
   
  Something like ORDER BY FIELD(ID, 10, 2, 56, 40);
   
  It is listed here:  http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html
   
  I am using the Sphinx Search program, www.sphinxsearch.com, and it returns a 
list of IDs ordered by relevance.  I take the array it gives me and create a 
comma separated list which is used in a postgres query using the WHERE "ID" IN 
(10, 2, 56, 40) statement.  I would like to order the result by the order of 
the list.
   
  Thanks.

   
-
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.