Postgres Pro
Downloads
Home   >   mailing lists

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

From Ben Chobot
Subject Re: Any was to prevent a join if no columns are selected from a view?
Date
Msg-id 10363436-7EE0-4967-A879-ABC8BED4C993@silentmedia.com
Whole thread Raw
In response to Any was to prevent a join if no columns are selected from a view?  (Jason Long <mailing.lists@octgsoftware.com>)
Responses Re: Any was to prevent a join if no columns are selected from a view?  (Jason Long <mailing.lists@octgsoftware.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Royce Ausburn
Date:
Subject: could not access file "$libdir/pg_buffercache": No such file or directory
Next
From: Royce Ausburn
Date:
Subject: Re: Any was to prevent a join if no columns are selected from a view?