Thread: Use of tsvector in array
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
Huang, Suya wrote
> 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')"
You will have to create some kind of custom operator. The easiest would be
to effectively duplicate the @@ operator but reverse the order of the
operands. Then you could do:
to_tsquery('ipod') @@^ ANY(tsvector_array)
Unfortunately the ANY must be applied to the right-hand type.
> * 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?
No clue but at a high level ISTM that tsvector[] is in many ways
functionally similar to "tsvector || tsvector" ... even if only for indexing
purposes
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Use-of-tsvector-in-array-tp5811210p5811215.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.