2 ms·
Using row values in PG: SELECT count(q.*) FROM (SELECT a, b FROM table_a a NATURAL FULL OUTER JOIN table_b b WHERE a IS NOT DISTINCT FROM N
by cryptonector 3y ago
Using row values in PG:
SELECT count(q.*)
FROM (SELECT a, b FROM table_a a
NATURAL FULL OUTER JOIN table_b b
WHERE a IS NOT DISTINCT FROM NULL
OR b IS NOT DISTINCT FROM NULL) q;
This looks for rows in `a` that are not in `b` and vice-versa and produces a count of those.
The key for this in SQL is `NATURAL FULL OUTER JOIN` (and row values).