On 1 Mar 2017, at 8:21pm, David Raymond <david.raym...@tomtom.com> wrote:
> The trigger version you asked about would look something like the below I > believe. More risky than having the two indexes, but should work. (Famous > last words) I have no doubt it would work. But look how much space and processing time it would take up. Far simpler and clearer just to create the two indexes. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
