NULLs are weird, PG15 makes them less weird
The Backend Engineering Show with Hussein Nasser
00:00
The New Syntax for Unique Knulls, Not Distinct
The default behavior is that effectivelythe carens behavior, which knulls are distinct. So if you insert ta noll, each knoll is to the deribis is a different knull. The team at rust proof here shows in the new style, supported by posces 15. What do we do? We create the same table, same thing here. Intger va, one, va, two, constraint, the costrat name, unique. Nulls, not distinct. They are all the same. And they effectively introduced a new syntax to solve this. If you consider it a problem on, if you consider the problem see on the next one.
Transcript
Play full episode
