Y
Hacker News
new
|
ask
|
show
|
jobs
by
Sesse__
409 days ago
IN is fine. The biggest problem comes with NOT IN, which has NULL semantics that makes life difficult for the planner. It is consistent but rarely what the user wants. NOT EXISTS is typically better there.