News for hackers. Stuff that matters.
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.
Re:Postgres 15 improves UNIQUE and NULL by mjevans on Monday July 11, 2022 @01:48PM (#32059309)
Thank you for pointing that out.

A better relationship would be if the order_suppliers table was the one with a relation to this table and there wasn't even a column.