<[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
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