News for hackers. Stuff that matters.
Re:Learn SQL, dammit by itsybitsycoder on Wednesday May 08, 2013 @02:59PM (#5676132)
I believe I read that in Postgres the query planner does the same thing whether you use EXISTS/NOT EXISTS or IN/NOT IN.

I don't think this is true, unless it's a very recent change. Here's a post from 2009 comparing NOT IN/NOT EXISTS/LEFT JOIN WHERE IS NULL for Postgres:

http://explainextended.com/2009/09/16/not-in-vs-not-exists-v...

Re:Learn SQL, dammit by pjungwir on Wednesday May 08, 2013 @03:45PM (#5676410)
In the NOT case, NOT IN and NOT EXISTS may even return different results! I think I knew that once and had forgotten. Good to be reminded!