On Sat, Nov 17, 2012 at 1:05 PM, Philip Taylor wrote:
> CREATE TABLE foo (
>x CHAR(32) PRIMARY KEY,
>y CHAR(32) NOT NULL,
>EXCLUDE USING gist ((ARRAY[x, y]) WITH &&)
> );
My first thought was you were going to have better luck with text
rather than char(n), but a little bit of experim
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 f
