Default operator class for data type boolean for access method gist is missing
| От | Andreas Joseph Krogh |
|---|---|
| Тема | Default operator class for data type boolean for access method gist is missing |
| Дата | |
| Msg-id | OfficeNetEmail.28c.ee96b3861c666d18.144ec49f396@prod2 обсуждение исходный текст |
| Ответы |
Re: Default operator class for data type boolean for access
method gist is missing
Re: Default operator class for data type boolean for access method gist is missing |
| Список | pgsql-general |
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);
But it fails with:
ERROR: data type boolean has no default operator class for access method "gist"
HINT: You must specify an operator class for the index or define a default operator class for the data type.
HINT: You must specify an operator class for the index or define a default operator class for the data type.
I have the btree_gist extension installed.
So, my question is; Is there an existing operator-class I can install to make this work, and if not - how do I make it?
I know I can change is_default to INTEGER and use 1 and 0, but I'd really like to use boolean for this.
Thanks.
--
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
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
В списке pgsql-general по дате отправления: