Ordering returned rows according to a list

Поиск
Список
Период
Сортировка
От Sebastian Tennant
Тема Ordering returned rows according to a list
Дата
Msg-id iqpcnn3p.fsf@vps203.linuxvps.org
обсуждение исходный текст
Ответы Re: Ordering returned rows according to a list
Список pgsql-general
Дерево обсуждения 
Hi all,

I'd like to make a single query that returns a number of rows using a
'WHERE id IN (<list-of-ids>)' condition, but I'd like the rows to be
returned in the order in which the ids are given in the list.

Is this possible?

Sebastian

В списке pgsql-general по дате отправления: