Discussion:
Use of tsvector in array
Huang, Suya
2014-07-11 00:47:43 UTC
Permalink
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
David G Johnston
2014-07-11 01:28:33 UTC
Permalink
Post by Huang, Suya
Hi,
We have the requirement of using the data type tsvector [], however, I
* Use array operator together with tsquery operator
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.
Post by Huang, Suya
* 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.
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Loading...