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

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: mailing(dot)lists(at)octgsoftware(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Any was to prevent a join if no columns are selected from a view?
Date: 2011-09-30 04:54:52
Message-ID: 10363436-7EE0-4967-A879-ABC8BED4C993@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Royce Ausburn 2011-09-30 04:59:33 Re: Any was to prevent a join if no columns are selected from a view?
Previous Message Royce Ausburn 2011-09-30 02:45:10 could not access file "$libdir/pg_buffercache": No such file or directory