NULLs: the good, the bad, the ugly, and the unknown | Postgres.FM 005 |
Nikolay and Michael discuss NULLs — including some problems they can cause, a new feature coming in Postgres 15, and some learning resources we like.
Subscribe via a popular podcast service: https://postgres.fm/subscribe
Here are links to a few things we mentioned:
- Three-valued_logic https://en.wikipedia.org/wiki/Three-v...
- Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert) https://blog.rustprooflabs.com/2022/0...
- Practical SQL for Data Analysis — Interpolation (blog post by Haki Benita) https://hakibenita.com/sql-for-data-a...
- What is the deal with NULLs? (blog post by Jeff Davis) http://thoughts.davisjeff.com/2009/08...
- NULL in SQL: Indicating the Absence of Data (Markus Winand on Modern SQL) https://modern-sql.com/concept/null
- The Art of PostgreSQL (book by Dimitri Fontaine) https://theartofpostgresql.com/