CODEWITHSUNDEEP
postgresqlfull-text-searchtsvector
sparkle
sparkle

Reputation: 7398

Intersections between ts_vector

I want to SELECT only records where the intersection of two ts_vector is with zero elements

--PSEUDO-CODE

SELECT
 ts_vector('german', query_a) vector_a,
 ts_vector('german', query_b) vector_b
FROM data
WHERE SIZE (vector_a INTERSECT vector_b ) = 0

Upvotes: 1

Views: 230

Answers (1)

jjanes
jjanes

Reputation: 44305

Convert them to arrays and then negate the overlap ('&&') operation.

WHERE NOT tsvector_to_array(vector_a) && tsvector_to_array(vector_b)

Upvotes: 4

Related Questions