Problem with result ordering

From: Thorsten Körner <t(dot)koerner(at)cappuccinosoft(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with result ordering
Date: 2007-01-25 15:45:23
Message-ID: 200701251645.23368.t.koerner@cappuccinosoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-01-25 15:48:04 Re: column limit
Previous Message Jim C. Nasby 2007-01-25 15:43:12 Re: Subject: Postgres processes have a burst of CPU usage