array exclusion constraint
| От | Philip Taylor |
|---|---|
| Тема | array exclusion constraint |
| Дата | |
| Msg-id | 1353175540.79593.YahooMailNeo@web160102.mail.bf1.yahoo.com обсуждение исходный текст |
| Ответы |
Re: array exclusion constraint
|
| Список | pgsql-hackers |
CREATE TABLE foo (
x CHAR(32) PRIMARY KEY,
y CHAR(32) NOT NULL,
EXCLUDE USING gist ((ARRAY[x, y]) WITH &&)
);
ERROR: data type character[] 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.
Neither gist nor gin work. You can do that with integers using the intarray extension module.
Could you please suggest me a clean way to achieve the same result (using the char data type, not integers)?
Probably I could create a specific operator class or some other workaround, but the intarray implementation looks a bit complex.
Someone so kind to point me in the right direction?
Of course the following produces the same error:
CREATE TABLE bar (
x VARCHAR[] NOT NULL,
EXCLUDE USING gist (x WITH &&)
);
В списке pgsql-hackers по дате отправления: