News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by jhgb on Monday July 11, 2022 @09:03AM (#32055618)
> It doesn't just mean "unknown". It can also mean "no value".

Isn't the canonical representation of known-no-value an absence of a tuple? Like as opposed to saying "There exists an employee X who works in department NULL", you simply don't make any claim about employee X working in a department? After all, when enumerating the members of a set, you're also omitting the enumeration of non-members of a set, and the law of excluded middle applies.

Re:Postgres 15 improves UNIQUE and NULL by Tostino on Monday July 11, 2022 @09:41AM (#32056000)
Nulls will reappear in your queries due to joins even if none exists in your data model.
Re:Postgres 15 improves UNIQUE and NULL by jhgb on Monday July 11, 2022 @02:39PM (#32059985)
Ah yes, they're the curse of SQL. Still doesn't seem to be a reason to not squash them out as much as feasible within the constraints of SQL.