Re: Problem with result ordering - Mailing list pgsql-general

From Ron Johnson
Subject Re: Problem with result ordering
Date
Msg-id 45B8D2E6.6040503@cox.net
Whole thread Raw
In response to Problem with result ordering  (Thorsten Körner <t.koerner@cappuccinosoft.de>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/25/07 09:45, Thorsten Körner wrote:
> 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?

What do you mean "same order"?  The order that they are listed in
the IN() clause?

I doubt it.  SQL is, by definition, set-oriented and the only ways
to guarantee a certain output sequence are ORDER BY and GROUP BY,
and they use collating sequences.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFuNLmS9HxQb37XmcRAmTSAJ9mbcf8AptR4YsjdG7xBocasldfdgCdEGSz
MNjSxmx3KBP79LXRzTgQ2Qk=
=nif4
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: btober@ct.metrocast.net
Date:
Subject: Re: SQL Newbie Question
Next
From: Ron Johnson
Date:
Subject: Re: SQL Newbie Question