Use of tsvector in array

From: "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Use of tsvector in array
Date: 2014-07-11 00:47:43
Message-ID: D83E55F5F4D99B4A9B4C4E259E6227CD014C312B@AUX1EXC01.apac.experian.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-07-11 00:50:14 Re: Windows Installation User account - Correct database for us
Previous Message John R Pierce 2014-07-11 00:43:23 Re: Windows Installation User account - Correct database for us