On 2018-Aug-08, KES wrote: > I do not know many internals and maybe wrong. > > But from my point of view with my current knowledge. > If such exclusion constraint would be marked as UNIQUE we can use it for FK > while implementing temporal/bi-temporal tables. > > And this will be simplify relationing while implementing them.
I think what you're looking for is "inclusion constraints" from Jeff Davis: https://postgr.es/m/1423354088.12308.117.camel@jeff-desktop -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
