Counting missing rows: PostgreSQL

This is the 5th of 5 articles covering implementation of NOT IN predicate in several RDBMS’es: NOT IN in MySQL NOT IN in MySQL (using DISTINCT) NOT IN in SQL Server NOT IN in Oracle NOT IN in PostgreSQL Finally let’s look how PostgreSQL copes with this predicate. Let’s create sample tables: Table creation details … Continue reading Counting missing rows: PostgreSQL