Handling Null Values in Postgres
An easy way to think about database nulls is how you would answer a question in real life about unknowns.<p>I have a friend James, and another friend Jane. I don&#x27;t know their ages. Are they of the same age?<p>Or Jane has a car. James has a blue car. Do car colours differ?<p>SQL provides human answers: explicitly answers &quot;I don&#x27;t know&quot;.<p>Other languages treat null as if it was just another value, providing very confusing answers. I wish all programming languages would use SQL style of null.