Re: Any was to prevent a join if no columns are selected from a view?

Поиск
Список
Период
Сортировка
От Jason Long
Тема Re: Any was to prevent a join if no columns are selected from a view?
Дата
Msg-id 1317394525.2348.35.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Any was to prevent a join if no columns are selected from a view?  (Ben Chobot <bench@silentmedia.com>)
Список pgsql-general
On Thu, 2011-09-29 at 22:54 -0600, Ben Chobot wrote:
On Sep 29, 2011, at 4:57 PM, Jason Long wrote:

I thought I had read somewhere that Postges could ignore a join if it
was not necessary because there were no columns from the table or view
selected in the query.  Is this possible?

This sounds like incorrect logic to me, so I would be surprised if it was possible.

That is the way it is looking.  I just modified my application to generate the join manually.

В списке pgsql-general по дате отправления:

Предыдущее
От: Karl Wright
Дата:
Сообщение: One-click installer, Windows 7 32-bit, and icacls.exe
Следующее
От: John R Pierce
Дата:
Сообщение: Re: stored procs