Is it possible somehow to group terms on either side of a NEAR operator
using fts4?
I'd like to use expression like:
"(predict OR foresee) NEAR (risk OR threat OR danger)"
That doesn't work, but I do get the results I expect from a query if I
permute the expressions, like this:
SELECT * FROM DOC_CHUNK_FT
WHERE DOC_CHUNK_FT match 'predict NEAR risk'
UNION ALL
SELECT * FROM DOC_CHUNK_FT
WHERE DOC_CHUNK_FT match 'predict NEAR danger'
UNION ALL
SELECT * FROM DOC_CHUNK_FT
WHERE DOC_CHUNK_FT match 'predict NEAR threat'
UNION ALL
SELECT * FROM DOC_CHUNK_FT
WHERE DOC_CHUNK_FT match 'forsee NEAR risk'
UNION ALL
SELECT * FROM DOC_CHUNK_FT
WHERE DOC_CHUNK_FT match 'forsee NEAR danger'
UNION ALL
SELECT * FROM DOC_CHUNK_FT
WHERE DOC_CHUNK_FT match 'foresee NEAR threat'
Yours sincerely,
--
Jim Ottaway
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
