Christopher Winslett: Postgres Calculations and the Ambiguity of NULL

How Postgres evaluates calculations when a value is unknown: three-valued logic, arithmetic and concatenation with NULL, NOT IN, aggregates and window functions, NULL sort order, and Postgres 19 IGNORE NULLS.