> On Jul 11, 2017, at 10:35 AM, Richard Hipp <d...@sqlite.org> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
