Re: WHERE condition not being pushed down to union parts

"John L. Clark" <jlc6(at)po(dot)cwru(dot)edu> writes:
> I have a database with two tables that relate similar data, and a view
> which projects and combines the data from these two tables in order to
> access them both in a consistent manner. With enough information, the
> application can specifically choose to query from one table or the
> other, but in the more general case the data could come from either
> table, so I need to query the view. When I join against the view (or
> an equivalent subselect), however, it looks like the joining condition
> is not pushed down into the individual components of the union that
> defines the view.

You never mentioned what PG version you are using, but I'm betting
it's 8.1.x. This should work the way you are expecting in 8.2 and up.

regards, tom lane