Hacker News new | ask | show | jobs
by bazoom42 1064 days ago
But how to represent missing values in left/right/outer joins?
1 comments

I think this one of the many things that the author wanted to point out, outer joins is not a valid relational model operator, and thus, leads to generating nulls. Outer joins would have to be some kind of subqueries in relational model, which would likely cause either way too subtle querying semantics or, as little as the would, still always unacceptable performance cost, given how databases are benchmarked.