Re: Many to many link tables with history?

unregister-pattern soe219(at)gmail(dot)com

On Thu, Oct 10, 2013 at 3:23 PM, Craig R. Skinner
<skinner(at)britvault(dot)co(dot)uk>wrote:

> On 2013-10-08 Tue 18:04 PM |, Craig R. Skinner wrote:
> > Hi folks, I'm new here. I hope this is the correct list....
> >
> > While creating a database of customer subscribed services with
> > DNS domains, I want to:
> > *) enable customers to subscribe to multiple services
> > *) each service can have multiple domain names per customer
> > *) a domain name must be unique per customer per timestamp
> >
>
> Probably (!!) solved by using a tstzrange exclusion constraint:
>
> http://dba.stackexchange.com/questions/51280/many-to-many-link-tables-with-history
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>