Re: Problem with nested query

> Denis Perchine <dyp(at)perchine(dot)com> writes:
> > As far as you can see it uses sequence scan for inner select. This is
> > quite strange as if I do this select with a constant it will use index
> > scan:
>
> Are the two tables' "email" fields declared as exactly the same
> datatype?

No...

> IIRC, 7.0.* has a problem with recognizing that a type-coerced parameter
> to an inner query is useful as an indexscan reference constant. This is
> fixed in current sources, but in the meantime avoiding an implicit type
> coercion is the easiest workaround.

OK. Thanks.

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------