"Michael Rothschild" <michael.r@corigin.co.il> writes:
> Based on what I saw (and maybe I didn't see enough) it seems that the
> optimizer will always decide to repeatedly scan the whole row set
> returned by sub selects in the context of an IN clause sequentially,
What version were you looking at?
regards, tom lane