PostgreSQL query returning multiple rows based on id

Question

I am trying to figure out how I can select multiple rows from a table, based on the id column. Something like this:

select * from table where id=1 and id=2 and id=3

Should I loop through every id and perform a query for each iteration?

Roman Pekar · Accepted Answer · 2013-08-26 18:09:48Z

up vote 1 down vote accepted

select *
from table
where id in (1, 2, 3)

answered Aug 26 '13 at 18:09

Roman Pekar
40.8k54281

add a comment |

Yan Brunet · Answer 2 · 2013-08-26 18:10:41Z

If you want to have results where id = 1 and results where id = 2 and results where id = 3, you have to use a different logic.

You actually want results where id = 1 or id = 2 or id = 3

Or you want results where id in (1, 2, 3)

Or you want results where id between 1 and 3

2 Answers 2