Re: WHERE clause OR vs IN

--- On Wed, 12/12/07, Medi Montaseri <montaseri(at)gmail(dot)com> wrote:

> based on your report, run time of OR is 0.275 ms and IN is
> 0.314
>
> > postgres=# explain analyze select * from tellers where
> bid in ('1','2');

Two other options are:

SELECT *
FROM Tellers
WHERE bin = ANY( '1', '2' );

and

SELECT T.*
FROM Tellers AS T
INNER JOIN ( VALUES ( '1' ), ( '2' ) ) AS B( bin )
ON T.bin = B.bin;

Regards,
Richard Broersma Jr.