Postgres Pro
Downloads
Home   >   mailing lists

Re: Default operator class for data type boolean for access method gist is missing - Mailing list pgsql-general

From Emre Hasegeli
Subject Re: Default operator class for data type boolean for access method gist is missing
Date
Msg-id CAE2gYzxCBA4nKw5PAbx-eGZ=p5_U9NJgUOj7sQZHtzdi=dNgYg@mail.gmail.com
Whole thread Raw
In response to Default operator class for data type boolean for access method gist is missing  (Andreas Joseph Krogh <andreak@officenet.no>)
Responses Re: Default operator class for data type boolean for access method gist is missing  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Default operator class for data type boolean for access method gist is missing
Next
From: Andreas Kretschmer
Date:
Subject: Re: Default operator class for data type boolean for access method gist is missing