Use of tsvector in array - Mailing list pgsql-general

From Huang, Suya
Subject Use of tsvector in array
Date
Msg-id D83E55F5F4D99B4A9B4C4E259E6227CD014C312B@AUX1EXC01.apac.experian.local
Whole thread Raw
Responses Re: Use of tsvector in array  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-general

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

 

 

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Windows Installation User account - Correct database for us
Next
From: David G Johnston
Date:
Subject: Re: Windows Installation User account - Correct database for us