SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-13-2008, 06:14 PM
| ||||
| ||||
 ORDER BY FIELD feature 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/...ting-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.      |
|
05-13-2008, 06:14 PM
| ||||
| ||||
| Re: ORDER BY FIELD feature 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/...ting-rows.html > > I am using the Sphinx Search program, www.sphinxsearch.com > <http://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 |
Linear Mode
