"Rod Taylor" <[EMAIL PROTECTED]> writes:
> Is this what the TODO entry 'Make IN / NOT IN have similar performance
> as EXISTS' means?
No. The TODO item is talking about IN with a sub-SELECT, which is not
optimized at all at the moment. IN with a list of scalar values is
converted to ((x = value1) OR (x = value2) OR ...), which we can do
something with.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
