Re: Default operator class for data type boolean for access method gist is missing

[Emre Hasegeli <emre@xxxxxxxxxxxx>]

2014-03-23, Andreas Joseph Krogh <andreak@xxxxxxxxxxxx>:

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.