> On Jul 11, 2017, at 10:35 AM, Richard Hipp <[email protected]> wrote: > > Generally speaking, FTS4 (and FTS3 and FTS5) requires no more than one > MATCH operator in the WHERE clause for each FTS4 table in the FROM > clause, and that one MATCH operator must be a conjunct.
Sorry, another question: Is it possible to work around this by putting each MATCH operation in a nested SELECT statement, and then combining the results of those statements? (I’d try this out myself in the CLI, but it gives ‘unknown tokenizer’ errors because we use a custom tokenizer for our FTS tables.) —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
