On 7/11/17, Jens Alfke <j...@mooseyard.com> wrote: > >> 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 think so, yes, depending on the details of your SELECT statement, of course. > > (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.) > Surely you should prioritize creating a loadable extension containing your custom tokenizer, for occasions such as this, no? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
