-----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-----
