2008/2/27, Bart Degryse <Bart.Degryse@indicator.be>:
>
>
> For rather "simple" queries like this one PostgreSQL indeed seems to be
> quite smart.
> I have quite a lot of statements where it does make a difference though
> (PostgreSQL 8.2.4).
I would rather find a situation where an explicit join is planned
significantly different than an equivalent IN to be a bug in
PostgreSQL:
Markus
--
Markus Bertheau
Blog: http://www.bluetwanger.de/blog/