Ken Tanzer <ken.tanzer@xxxxxxxxx> 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
