select where expr in - result order?

Поиск
Список
Период
Сортировка
От Andy Kriger
Тема select where expr in - result order?
Дата
Msg-id OJEFIHHAALOBKKJEOMBDKEEFCIAA.akriger@greaterthanone.com
обсуждение исходный текст
Список pgsql-general
Is there any way to guarantee that the when using
SELECT * FROM tbl WHERE expr IN (scalar[,...])
the results are returned in the same order as the scalar list?

I realize I can do this by sorting the scalar list and using ORDER BY expr,
but I'd like to not count on a sorted list of scalars if at all possible.

thx
andy



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