NULLs are weird, PG15 makes them less weird

The Backend Engineering Show with Hussein Nasser

Episode | Podcast

Date: Wed, 13 Jul 2022 20:52:25 GMT

<p>Postgres 15 introduces a new syntax to treat nulls as not distinct. This will allow developers to create a unique constraint on nullable fields and have inserts with nulls fail instead of having it allowed based on today's standard.</p> <p>Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)</p> <p>https://network.husseinnasser.com</p> <p>Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)</p> <p>https://database.husseinnasser.com</p> <p><br /></p> <p>https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null</p> <p>https://www.postgresql.org/message-id/flat/84e5ee1b-387e-9a54-c326-9082674bde78%40enterprisedb.com</p> <p><br /></p>