selecting data from subquery in same order - Mailing list pgsql-general

From mark
Subject selecting data from subquery in same order
Date
Msg-id 82fa9e310808161711l7d1e2b88uc09006a2065a1247@mail.gmail.com
Whole thread Raw
Responses Re: selecting data from subquery in same order
Re: selecting data from subquery in same order
List pgsql-general
hi
if i execute this statement:

select * from users where id in (2341548, 2325251, 2333130, 2015421,
2073536, 2252374, 2273219, 2350850, 2367318, 2032977, 2032849, )

the order of rows obtained is random.

is there anyway i can get the rows in the same order as the ids in
subquery? or is there a different statement i can use?
thanks!

pgsql-general by date:

Previous
From: Decibel!
Date:
Subject: Re: Changing between ORDER BY DESC and ORDER BY ASC
Next
From: "Scott Marlowe"
Date:
Subject: Re: Confronting the maximum column limitation