Horton

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

Andreas Joseph Krogh <andreak@officenet.no>

View thread View on postgr.es
From: Andreas Joseph Krogh <andreak@officenet.no>
To: pgsql-general@postgresql.org
Date: 2014-03-23T09:22:03Z
Lists: pgsql-general 
På søndag 23. mars 2014 kl. 08:13:43, skrev Emre Hasegeli <emre@hasegeli.com 
<mailto:emre@hasegeli.com>>: 2014-03-23, Andreas Joseph Krogh <
andreak@officenet.no <mailto:andreak@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 <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