Re:Postgres 15 improves UNIQUE and NULL
by pprotas on Monday July 11, 2022 @05:25AM
(#32053936)
You could create a new table that keeps track of the logistics of the product. If the product is sent to supplier, a new row appears in this table with the date. If it hasn't been sent yet, no row is present.
[ Parent
| on HN ]
Handles the cases where an order had to be resent to the supplier better as well.
Re:Postgres 15 improves UNIQUE and NULL
by formercoder on Monday July 11, 2022 @06:11AM
(#32054235)
And when a supplier returns a shipment, and when new things happen that you haven’t thought of so a new column isn’t needed.