On 14 Jun 2017, at 12:52pm, Paul Sanderson <sandersonforens...@gmail.com> wrote:
> The only benefit I can see is that you know the imposter table is showing > you exactly what is in the index, where the view is my interpretation of > the SQL needed to show what is in the index. Is this the main benefit? or > am I missing something? Hmm. If you create a view with calculated columns, and then create an impostor table on that view, do you get a virtual table with pre-calculated columns ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users