Re: Subqueries and the optimizer

"Dmitri Bichko" <dbichko(at)genpathpharma(dot)com> writes:
> Thanks anway, guess I'll wait for 7.4 with this (and just split them up
> into two queries for the time being),

As I was just saying to someone else, it'd be worth testing complex IN
cases against CVS tip to make sure that 7.4 will do a decent job with
them. It's not too late now to consider improving any gaps that might
remain --- but by the time we start the formal beta process, it will be.
So I encourage you to grab a CVS-tip snapshot and set up a test database
to check out the cases you are interested in. Please report what you
find out to pgsql-hackers.

regards, tom lane