4 ms·
You should investigate exclusion constraints. Another scenario where they come in handy is a calendar interface where you need to ensure no overlapping per rec
by imperialWicket 14y ago
You should investigate exclusion constraints. Another scenario where they come in handy is a calendar interface where you need to ensure no overlapping per record per time.
- vog 14y agoIndeed, exclusion constrains are really neat! FTR, here's their description in the PostgreSQL manual: http://www.postgresql.org/docs/9.1/static/sql-createtable.html#SQL-CREATETABLE-EXCLUDE http://www.postgresql.org/docs/9.1/static/sql-createtable.ht...
- famousactress 14y agoOh wow. These are pretty wacky/interesting. Also, sign of a well designed API: I think I gleaned more understanding from reading an actual EXCLUDE constraint definition than I did from reading the description of what it does in the docs.