Re: Exclusion constraints on overlapping text arrays?

Ken Tanzer <ken.tanzer@gmail.com> writes:
> Hi.  Using 9.6.14, I was setting up a table with this:
> EXCLUDE using gist (EXCLUDE using gist (grant_number_codes with &&)
> Where grant_numbers is a varchar[].  I get this error:
> ERROR:  data type character varying[] has no default operator class for
> access method "gist"

> I did some Googling, and it looks like you could do this for integer arrays
> with the intarray extension.  I didn't see anything I'd recognize as an
> equivalent for varchar (or text) arrays.  Is there any way to do this now?
> And if not, is there much prospect of this being implemented at some point?

I haven't heard of anyone working on it recently.

> Also, on a side note, I tried using grant_number_codes::text[] with &&, but
> that got a syntax error.  Does that mean casting isn't allowed at all in
> these constraints?

As far as that goes, you'd just need to add parentheses.

            regards, tom lane