Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Why NESTED LOOP Not Allowed for FULL and RIGHT Join.
Date
Msg-id 29438.1187618978@sss.pgh.pa.us
Whole thread Raw
In response to Why NESTED LOOP Not Allowed for FULL and RIGHT Join.  ("Rushabh Lathia" <rushabh.lathia@gmail.com>)
List pgsql-hackers
Tree view 
"Rushabh Lathia" <rushabh.lathia@gmail.com> writes:
> can anyone let me know that why Nested Loop path is not allowed if jointype
> are JOIN_RIGHT or JOIN_FULL?

How are you going to track which of the inner-relation rows never find a
join partner and hence need to be emitted on their own?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: random crashes on -HEAD for a few days now
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: random crashes on -HEAD for a few days now