GIST exclude constraint with a specific value
It sounds like you need a partial constraint.
alter table a_table add constraint foobar exclude using gist 
    (tstzrange(&quot;start_time&quot;, &quot;end_time&quot;) WITH &amp;&amp;) where (active);