Preventing adjacent/overlapping entries with EXCLUDE in PostgreSQL
Range types consist of lower and upper bound, and each can be included or excluded. The canonical form (and default for range types) is to include the lower and exclude the upper bound. Inclusive bounds ‘[]’ You could include lower and upper bound ([]), and enforce it with a CHECK constraint using range functions. Then … Read more