Hello! How about solution like to
select rowid from my_fts_table
where my_fts_table match @query2 and rowid in
(select rowid from my_fts_table where my_fts_table match @query1)
limit 21
I don't know about performance of this but rowid index may be used success.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
