"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