Re: Any was to prevent a join if no columns are selected from a view? - Mailing list pgsql-general

From Jason Long
Subject Re: Any was to prevent a join if no columns are selected from a view?
Date
Msg-id 1317394525.2348.35.camel@localhost.localdomain
Whole thread Raw
In response to Re: Any was to prevent a join if no columns are selected from a view?  (Ben Chobot <bench@silentmedia.com>)
List 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 by date:

Previous
From: Karl Wright
Date:
Subject: One-click installer, Windows 7 32-bit, and icacls.exe
Next
From: John R Pierce
Date:
Subject: Re: stored procs