Re:Postgres 15 improves UNIQUE and NULL
by stdbrouw on Monday July 11, 2022 @06:03AM
(#32054187)
These all seem like fine examples of solutions that are worse than the problem they were meant to solve. A separate table will be harder and slower to query and will enable M2M relationships even when you don't want those. Sentinel values must be dealt with at every query to ensure they are always filtered out.
[ Parent
| on HN ]