On Sat, Nov 17, 2012 at 1:05 PM, Philip Taylor <philiptaylor51@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