På søndag 23. mars 2014 kl. 08:13:43, skrev Emre Hasegeli <e...@hasegeli.com
<mailto:e...@hasegeli.com>>: 2014-03-23, Andreas Joseph Krogh <
andr...@officenet.no <mailto:andr...@officenet.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 <andr...@officenet.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
