Factoring where clauses through unions - Mailing list pgsql-general

From Jonathan Bartlett
Subject Factoring where clauses through unions
Date
Msg-id Pine.GSU.4.44.0304041240451.5429-100000@eskimo.com
Whole thread Raw
Responses Re: Factoring where clauses through unions  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
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?

Thanks,

Jon


pgsql-general by date:

Previous
From: "Wayne Armstrong"
Date:
Subject: Re: feature request - adding columns with default value
Next
From: nolan@celery.tssi.com
Date:
Subject: Re: Getting consecutive sequence values