Re: Factoring where clauses through unions

On Friday April 4 2003 1:42, Jonathan Bartlett wrote:
> I have a view that is based on several UNION clauses.  I'm wondering, if
> I select data from there, will it UNION first, and then apply my where
> clauses, or can it factor my where clauses through the UNION?  If it
> doesn't do it automatically, is there any way to automate it?

For cases like this, you can usually construct a very simple test to get the
answer.  But let's see your view creation command so we know what you're
talking about.

Ed