Why NESTED LOOP Not Allowed for FULL and RIGHT Join. - Mailing list pgsql-hackers

From Rushabh Lathia
Subject Why NESTED LOOP Not Allowed for FULL and RIGHT Join.
Date
Msg-id 460abcb10708200701x6e496f96m2b0048dc22748237@mail.gmail.com
Whole thread Raw
Responses Re: Why NESTED LOOP Not Allowed for FULL and RIGHT Join.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
<br />Hi,<br /><br />can anyone let me know that why Nested Loop path is not allowed if jointype<br />are JOIN_RIGHT or
JOIN_FULL?<br/><br /><br />At match_unsorted_outer(), we having case where nestjoinOK = false if there are<br
/>JOIN_RIGHTor JOIN_FULL. <br /><br />match_unsorted_outer()<br />{<br />....<br />        case JOIN_RIGHT:<br />   
   case JOIN_FULL:<br />            nestjoinOK = false;<br /><br />..<br />}<br /><br />wondering why ?<br /><br
/>Regards,<br/>Rushabh Lathia <br /><br /><a href="mailto:rushabh.lathia@EnterpriseDB.com">
rushabh.lathia@EnterpriseDB.com</a><br/> 

pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: PAM authentication fails for local UNIX users
Next
From: Tom Lane
Date:
Subject: Re: random crashes on -HEAD for a few days now