How to fetch rows with multiple values - Mailing list pgsql-general

Hi,

I have a table like this:

CREATE TABLE customer_mapping
(
  "Name" varchar(128) NOT NULL,
  "ID" int8 NOT NULL
)

Data looks something like this:

"john"     1
"peter"    1
"test"      2
"george"  3

What I would like is to write a query where I can specify multiple names and get the IDs which have them.

For now it seems the most efficient way is to use INTERSECT statement:

SELECT "ID" from customer_mapping WHERE "Name"='john'
INTERSECT
SELECT "ID" from customer_mapping WHERE "Name"='peter'

Although, I don't know how exactly to use ORDER, OFFSET and LIMIT in this case...

Anyway, is there any better way of doing this? (I can't change the table structure.)

Thanks, Sebastjan