Can you create an imposter table on a view. A view has no associated b-tree so I would think not!
Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 14 June 2017 at 13:11, Simon Slavin <slav...@bigfraud.org> wrote: > > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users