Re:Why Use Postgres?
by jeltz on Sunday April 30, 2017 @08:19PM
(#14234692)
You still would need PostgreSQL's exclusion constraints to handle overlapping ranges since unqiue constraints do not handle checking for overlapping ranges, only exact equality. The below example guarantees that the same room can only be booked once.
You could also still have two columns and use an expression.
[ Parent
| on HN ]
There are no comments on this comment yet.