Re: Factoring where clauses through unions - Mailing list pgsql-general

From Ed L.
Subject Re: Factoring where clauses through unions
Date
Msg-id 200304041619.25554.pgsql@bluepolka.net
Whole thread Raw
In response to Factoring where clauses through unions  (Jonathan Bartlett <johnnyb@eskimo.com>)
Responses Re: Factoring where clauses through unions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: Getting consecutive sequence values
Next
From: Tom Lane
Date:
Subject: Re: Factoring where clauses through unions