NULLs: the good, the bad, the ugly, and the unknown
Nikolay and Michael discuss NULLs — including some problems they can cause, a new feature coming in Postgres 15, and some learning resources we like.
Here are links to a few things we mentioned:
- Three-valued_logic (Wikipedia)
- Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert)
- Practical SQL for Data Analysis — Interpolation (blog post by Haki Benita)
- What is the deal with NULLs? (blog post by Jeff Davis)
- NULL in SQL: Indicating the Absence of Data (Markus Winand on Modern SQL)
- The Art of PostgreSQL (book by Dimitri Fontaine)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
