Use of tsvector in array

["Huang, Suya" <Suya.Huang@xxxxxxxxxxxxxxx>]

Hi,

 

We have the requirement of using the data type tsvector [], however, I didn’t find out how to:

·         Use array operator together with tsquery operator

o   I have to unnest the array and then do query like “ts@@ to_tsquery('ipod')”

·         Create GIN index on tsvector[]

o   ERROR:  data type tsvector[] has no default operator class for access method "gin"

 

Not sure if anyone ever has this experience could share?

 

Thanks,

Suya