Re: Factoring where clauses through unions

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Factoring where clauses through unions
Date: 2003-04-04 23:19:25
Message-ID: 200304041619.25554.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-04 23:41:59 Re: Factoring where clauses through unions
Previous Message nolan 2003-04-04 23:08:34 Re: Getting consecutive sequence values