Problem with result ordering
От | Thorsten Körner |
---|---|
Тема | Problem with result ordering |
Дата | |
Msg-id | 200701251645.23368.t.koerner@cappuccinosoft.de обсуждение исходный текст |
Ответы |
Re: Problem with result ordering
Re: Problem with result ordering Re: Problem with result ordering Re: Problem with result ordering |
Список | pgsql-general |
Hi, when I fire the following query: select m_id, m_u_id, m_title, m_rating from tablename where m_id in (26250, 11042, 16279, 42197, 672089); I will get the same results in the same order, as in in the next query: select m_id, m_u_id, m_title, m_rating from tablename where m_id in (11042,42197,672089,26250,16279); I wonder, how it is possible, to retrieve the results in the same order, as queried in the list. The listed IDs are from an application outside the database. Version is PostgreSQL 8.2.1 Has anyone an idea, how to do this, while PostgreSQL knows nothing about hints, like oracle does? THX, Thorsten
В списке pgsql-general по дате отправления: