Postgres Pro
Downloads
Home   >   mailing lists

SQL question.. - Mailing list pgsql-general

From Alexis Maldonado
Subject SQL question..
Date
Msg-id 006d01c1e630$0b8356a0$14818b0a@ctcd.cc.tx.us
Whole thread Raw
List pgsql-general
Tree view
I know this might be a dumb basic sql question but..
 
I have a query list of IDs ( 4,3,1,2,12,5,6,8,7,9,11)
 
I want to build a query that gets those IDs in the exact same order but when i do
 
Select * From Table
Where ID IN ( 4,3,1,2,12,5,6,8,7,9,11)
 
It gets all the IDs in random order..
 
how can i get them in the order listed?
 
Thanks,
Alex

pgsql-general by date:

Previous
From: Matthew Stanfield
Date:
Subject: Re: Incorrect password using pg_ctl
Next
From: Stephan Szabo
Date:
Subject: Re: Large table update/vacuum PLEASE HELP!