Thread: Stop restarting of inner plan??

Hello,

Can someone tell me how can i let the inner plan in a nestloop join NOT to 
restart for each tuple of the outer Plan ..
so essentially, my inner plan has to be executed only once and not 'n' times 
.. where 'n' is the number of outer tuples ...

I tried by commenting ExecReScan(innerPlan, econtext, (Plan *) node);  at 
line # 154 in nodeNestLoop.c .. but that is not working out !! :-\

Some one can please educate me about what is happenning !!!

-Ramu

_________________________________________________________________
Contact brides & grooms FREE! http://www.shaadi.com/ptnr.php?ptnr=hmltag 
Only on www.shaadi.com. Register now!

"Ramanujam H S Iyengar" <hals_ramu@hotmail.com> writes:
> Can someone tell me how can i let the inner plan in a nestloop join NOT to 
> restart for each tuple of the outer Plan ..

You can't.  At least, not if you want the correct results from the join.
        regards, tom lane