Is it possible to make the order of output the same as the order of input parameters? - Mailing list pgsql-general

Hi,

I have a simple query like:

SELECT * FROM customer WHERE id IN (23, 56, 2, 12, 10)

The problem is that I need to retrieve the rows in the same order as the set of ids provided in the select statement. Can it be done?

Thanks


pgsql-general by date:

Previous
From:
Date:
Subject: Re: create index concurrently - duplicate index to reduce time without an index
Next
From: Stephen Frost
Date:
Subject: Re: Disable executing external commands from psql?