Postgres Pro
Downloads
Home   >   mailing lists

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

From m. hvostinski
Subject Is it possible to make the order of output the same as the order of input parameters?
Date
Msg-id AANLkTin1qnRa4Bowqcj-4RzEos-Jt2ITkc25kRbz8AZd@mail.gmail.com
Whole thread Raw
Responses Re: Is it possible to make the order of output the same as the order of input parameters?  (Stephen Frost <sfrost@snowman.net>)
Re: Is it possible to make the order of output the same as the order of input parameters?  (Sam Mason <sam@samason.me.uk>)
Re: Is it possible to make the order of output the same as the order of input parameters?  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Is it possible to make the order of output the same as the order of input parameters?  (David Fetter <david@fetter.org>)
List pgsql-general
Tree view
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?