On Sat, Nov 17, 2012 at 1:05 PM, Philip Taylor <philiptaylo...@yahoo.com> 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 experimentation suggests to me that that doesn't work either. It seems that GIN doesn't support exclusion constraints and there's no gist opclass for text[], varchar[], or anyarray. Bummer. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
