Postgres Pro
Downloads
Home   >   mailing lists

Ordering returned rows according to a list - Mailing list pgsql-general

From Sebastian Tennant
Subject Ordering returned rows according to a list
Date
Msg-id iqpcnn3p.fsf@vps203.linuxvps.org
Whole thread Raw
Responses Re: Ordering returned rows according to a list  ("Adam Rich" <adam.r@sbcglobal.net>)
List pgsql-general
Tree view 
Hi all,

I'd like to make a single query that returns a number of rows using a
'WHERE id IN (<list-of-ids>)' condition, but I'd like the rows to be
returned in the order in which the ids are given in the list.

Is this possible?

Sebastian

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: lack of consequence with domains and types
Next
From: paulo matadr
Date:
Subject: Erro in vaccum