DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=pd3uUMADs+kN44jvPkQti7Ukbi29VhzSkMhkePHxidgtBrKzZ3PrKSBB7eKtZtCDKhjSgPKpgnIkz6r411mo3S1yyLcP4Zd1yPt2eg/p+xTUL0dornQTuB7N6ZakTM8+8GuT7dxkCjp8kfofae6jSWzl9ujRSLLXrmJDFmxgJBE=
Message-ID: <758d5e7f05063000514ece9e33@mail.gmail.com>
Date: Thu, 30 Jun 2005 09:51:35 +0200
From: Dawid Kuroczko <qnex42@gmail.com>
Reply-To: Dawid Kuroczko <qnex42@gmail.com>
To: "M.D.G. Lange" <mlange@dltmedia.nl>, pgsql-sql@postgresql.org
Subject: Re: ORDER records based on parameters in IN clause
In-Reply-To: <42C3A0A3.40101@dltmedia.nl>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <BAY103-F2C56F6C371B9B2FDEEDCBB5E00@phx.gbl>
	<1120057638.8208.117.camel@state.g2switchworks.com>
	<42C3A0A3.40101@dltmedia.nl>

On 6/30/05, M.D.G. Lange <mlange@dltmedia.nl> wrote:
> Another option would be:
> SELECT * FROM table WHERE id=3D2003 OR id=3D1342 OR id=3D799 OR id=3D1450=
;
> This should give you the results in the right order...

I don't think so...


create temporary table seq as select * from generate_series(1,20) as g(id);
select * from seq where id in (5,2,12);
 id=20
----
  2
  5
 12


select * from seq where id =3D 5 or id =3D 2 or id =3D 12;
 id=20
----
  2
  5
 12

It certainly doesn't work.

You have to order it by something, like:

select * from seq where id in(5,2,12) order by id=3D5 desc,id=3D2 desc,id=
=3D12 desc;
 id=20
----
  5
  2
 12


Regards,
    Dawid