Episode 5
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.
Postgres FM · Nikolay Samokhvalov and Michael Christofides
August 5, 202227m 10s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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 elephant artwork
Topics
PostgresPostgreSQLDatabasesSQLtechnology