--- 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.