Re: [PERFORM] Convert IN sublink to join

2005-12-14 Thread Tom Lane
<[EMAIL PROTECTED]> writes: > /* >* The sub-select must not refer to any Vars of the parent query. >* (Vars of higher levels should be okay, though.) >*/ > if (contain_vars_of_level((Node *) subselect, 1)) > return NULL; > By commenting this code

[PERFORM] Convert IN sublink to join

2005-12-14 Thread francisco.santos
Title: Dear Sir or Madam: Dear Sir or Madam: The function "convert_IN_to_join(Query *parse, SubLink *sublink)", from file: /src/backend/optimizer/plan/subselect.c, is responsible for converting IN type sublinks to joins, whenever appropriate. The following lines of code, extracted from co