News for hackers. Stuff that matters.
Re:Creating a Document-Store Hybrid in Postgres 9.5 by anarazel on Friday February 05, 2016 @04:39PM (#11044853)
Using NOT EXISTS() is a lot better than NOT IN(). The latter, as defined by the SQL standard, has confusing behaviour with NULLs. x NOT IN(y1, y2) is defined to expand to x <> y1 AND x <> y2. If any of these are NULL, the whole expression is NULL. Which means no rows match. Fun, ain't it?

There are no comments on this comment yet.