Josh Sacks <[EMAIL PROTECTED]> writes: > I can't understand what's going on in this simple query:
If you are using anything older than PG 7.4, you should not expect good
performance from WHERE ... IN (sub-SELECT) queries. There's essentially
no optimization happening there.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
