På søndag 23. mars 2014 kl. 08:13:43, skrev Emre Hasegeli <emre(at)hasegeli(dot)com
<mailto:emre(at)hasegeli(dot)com>>: 2014-03-23, Andreas Joseph Krogh <
andreak(at)officenet(dot)no <mailto:andreak(at)officenet(dot)no>>: I'm trying to define the
following exclusion-constraint alter table my_table add EXCLUDE USING gist
(is_defaultWITH =, daterange(valid_from, valid_to, '[)') WITH &&) WHERE
(is_default =true); is_default should not be in the index as only one
value filtered on the WHERE clause. Thanks. If I had more filters in WHERE,
then what? --
Andreas Joseph Krogh <andreak(at)officenet(dot)no> mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc