dag@nimrod.no writes:
> The test case below demonstrates that the planner pushes down the WHERE (ON)
> clause in a UNION ALL view, but fails to push down the WHERE (ON) clause
> when a JOIN clause is introduced in the view.
> Any simple fix? :-)
No.
(See is_safe_append_member() for why not.)
regards, tom lane
