Dave Johansen <davejohansen@gmail.com> writes:
> ... So is there a way to make the
> planner perform the same sort of operation and push those same constraints
> into the sub-queries on its own?
No. As was mentioned upthread, there is a solution for this in 9.1,
although it doesn't work in exactly the way you suggest.
regards, tom lane
