Re: Multiple IN

Leandro,

> Maybe this is a silly question. I have a table t with two fields f1
> and
> f2. Those fields together form the primary key. I want to select a
> list
> of pairs from that table. The simplest SQL clause would be
>
> SELECT * FROM t WHERE (f1 = v1 AND f2 = v2) OR (f1 = v3 AND f2 = v4)
> ...;

We'll need database schema (table designs) if you want us to help you.
The above isn't enough information to go on. For example, where did
"v1" come from? Is this a field? An interface language variable?

Please be explicit! Also, consider picking up Joe Celko's SQL for
Smarties, reviewed at http://techdocs.postgresql.org/bookreviews.php

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco