Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins. - Mailing list pgsql-committers

From Robert Haas
Subject Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.
Date
Msg-id AANLkTi=MDaMvTDhzQiSa3LaMGXx_8ScgPaRramzFxd7M@mail.gmail.com
Whole thread Raw
In response to pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Tree view 
On Thu, Dec 30, 2010 at 8:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Support RIGHT and FULL OUTER JOIN in hash joins.

This is cool, but on first blush your changes to
add_paths_to_joinrel() appear to be total nonsense.  I think the
problem is that have_nonmergeable_clause is really a misnomer - it's
not clear until you read through the whole diff that this won't get
set for inner/left joins.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Support RIGHT and FULL OUTER JOIN in hash joins.