Factoring where clauses through unions

Поиск
Список
Период
Сортировка
От Jonathan Bartlett
Тема Factoring where clauses through unions
Дата
Msg-id Pine.GSU.4.44.0304041240451.5429-100000@eskimo.com
обсуждение исходный текст
Ответы Re: Factoring where clauses through unions  ("Ed L." <pgsql@bluepolka.net>)
Список 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 по дате отправления:

Предыдущее
От: "Wayne Armstrong"
Дата:
Сообщение: Re: feature request - adding columns with default value
Следующее
От: nolan@celery.tssi.com
Дата:
Сообщение: Re: Getting consecutive sequence values