Factoring where clauses through unions

From: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Factoring where clauses through unions
Date: 2003-04-04 20:42:33
Message-ID: Pine.GSU.4.44.0304041240451.5429-100000@eskimo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nolan 2003-04-04 20:53:36 Re: Getting consecutive sequence values
Previous Message Wayne Armstrong 2003-04-04 20:02:21 Re: feature request - adding columns with default value