Stop restarting of inner plan?? - Mailing list pgsql-hackers

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!