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

Поиск
Список
Период
Сортировка
От Emre Hasegeli
Тема Re: Default operator class for data type boolean for access method gist is missing
Дата
Msg-id CAE2gYzxCBA4nKw5PAbx-eGZ=p5_U9NJgUOj7sQZHtzdi=dNgYg@mail.gmail.com
обсуждение исходный текст
Ответ на Default operator class for data type boolean for access method gist is missing  (Andreas Joseph Krogh <andreak@officenet.no>)
Ответы Re: Default operator class for data type boolean for access method gist is missing  (Andreas Joseph Krogh <andreak@officenet.no>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Default operator class for data type boolean for access method gist is missing
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Default operator class for data type boolean for access method gist is missing