Horton

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

Emre Hasegeli <emre@hasegeli.com>

View thread View on postgr.es
From: Emre Hasegeli <emre@hasegeli.com>
To: Andreas Joseph Krogh <andreak@officenet.no>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2014-03-23T07:13:43Z
Lists: pgsql-general 
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.