ERROR: data type character
varying[] 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 for the data type.
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 found a couple of old threads about this. Not sure if
they are still relevant, but listed below.
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?
