[email protected] 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to