På søndag 23. mars 2014 kl. 08:13:43, skrev Emre Hasegeli <[email protected]
<mailto:[email protected]>>: 2014-03-23, Andreas Joseph Krogh <
[email protected] <mailto:[email protected]>>: 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 <[email protected]> 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
