d...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs