Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: mailing.lists@xxxxxxxxxxxxxxxx
Subject: Re: Any was to prevent a join if no columns are selected from a view?
From: Ben Chobot <bench@xxxxxxxxxxxxxxx>
Date: Thu, 29 Sep 2011 22:54:52 -0600
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <1317337039.2348.33.camel@localhost.localdomain>

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Any was to prevent a join if no columns are selected from a view?
  - From: Jason Long

References:
- Any was to prevent a join if no columns are selected from a view?
  - From: Jason Long

Prev by Date: could not access file "$libdir/pg_buffercache": No such file or directory
Next by Date: Re: Any was to prevent a join if no columns are selected from a view?
Previous by thread: Any was to prevent a join if no columns are selected from a view?
Next by thread: Re: Any was to prevent a join if no columns are selected from a view?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux