PostgreSQL INT4RANGE: enforce non-overlapping zones in SQL
Let the database refuse overlapping ranges, so the app does not have to check.
One method, four stages, from the first scope to long-term care. Jump to a stage:
The products we have built and shipped ourselves. We feel the pain, build for our own team, then extract the product.
Let the database refuse overlapping ranges, so the app does not have to check.