On 10/18/2014 11:57 PM, ve3meo wrote:
I was delighted with having NOT, AND, OR operators in FTS among other capabilities. To incorporate all three in the recursive search is non-obvious.
It was a toy example. You asked "Is it at all possible..." and I'm like "challenge accepted". While possible (if I recall correctly, SQL with CTE is Turing-complete), I would not recommend it in practice. Do use FTS, it was designed for this kind of queries.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users