"Michael Rothschild" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend