2014-03-23, Andreas Joseph Krogh <andreak@officenet.no>: I'm trying to define the following exclusion-constraint
alter table my_table add EXCLUDE USING gist (is_default WITH =, 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@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
