DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=QM/gKf1ra4659IFXJJMJARhksQayLS8M3ew0MIe02SFliW1lwztzWlobFFEXHoXxc2J7YI94vjzaHjjsP8NshhNUZZI5XrhcvngpjLOT196R9Th1aqPZm4SCQwbVsUS23RQ+UQsl7f0evNR2r/dPTTkq+qMMNl3aKfiZdv4NnlY=
Message-ID: <758d5e7f05062904445112c493@mail.gmail.com>
Date: Wed, 29 Jun 2005 13:44:00 +0200
From: Dawid Kuroczko <qnex42@gmail.com>
Reply-To: Dawid Kuroczko <qnex42@gmail.com>
To: Riya Verghese <riya.verghese@admissioncorp.com>
Subject: Re: ORDER records based on parameters in IN clause
Cc: pgsql-sql@postgresql.org
In-Reply-To: 
 <BBA4F47BB0CEDD4D8ADD2FE21E2823673110A4@dhost002-37.dex002.intermedia.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: 
 <BBA4F47BB0CEDD4D8ADD2FE21E2823673110A4@dhost002-37.dex002.intermedia.net>

On 6/27/05, Riya Verghese <riya.verghese@admissioncorp.com> wrote:
> I have a stmt where the outer-query is limited by the results of the inne=
r
> query. I would like the outer query to return records in the same order a=
s
> the values provided in the IN clause (returned form the inner query).=20
>=20
> The inner_query is returning id's ordered by count(id) , i.e by most comm=
on
> occurrence.=20
>=20
> In essence,=20
>=20
> when I say=20
>=20
> select * from table where id IN (2003,1342,799, 1450)=20
>=20
> Currently postgres returns it in this order (1450,1342,799,2003)=20

Simplest, though not niciest solution would be:

SELECT * FROM table WHERE id IN (2003,1342,799,1450) ORDER BY id =3D
2003 DESC, id =3D 1342 DESC, id =3D 799 DESC, id =3D 1450 DESC;

You could write a function which will return position of interger
inside integer[] array and use it as order key. :-)

   Regards,
       Dawid