Re: Many to many link tables with history?

<div dir="ltr"><pre style="color:rgb(0,0,0)"> unregister-pattern <a
href="mailto:soe219@gmail.com">soe219@gmail.com</a></pre></div><divclass="gmail_extra"><br /><br /><div
class="gmail_quote">OnThu, Oct 10, 2013 at 3:23 PM, Craig R. Skinner <span dir="ltr"><<a
href="mailto:skinner@britvault.co.uk"target="_blank">skinner@britvault.co.uk</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On 2013-10-08
Tue18:04 PM |, Craig R. Skinner wrote:<br /> > Hi folks, I'm new here. I hope this is the correct list....<br />
><br/> > While creating a database of customer subscribed services with<br /> > DNS domains, I want to:<br />
>*) enable customers to subscribe to multiple services<br /> > *) each service can have multiple domain names per
customer<br/> > *) a domain name must be unique per customer per timestamp<br /> ><br /><br /></div>Probably (!!)
solvedby using a tstzrange exclusion constraint:<br /><a
href="http://dba.stackexchange.com/questions/51280/many-to-many-link-tables-with-history"
target="_blank">http://dba.stackexchange.com/questions/51280/many-to-many-link-tables-with-history</a><br/><div
class="HOEnZb"><divclass="h5"><br /><br /><br /> --<br /> Sent via pgsql-sql mailing list (<a
href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br/> To make changes to your subscription:<br /><a
href="http://www.postgresql.org/mailpref/pgsql-sql"target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br
/></div></div></blockquote></div><br/></div>