Re: [sqlite] FTS Append?

On Saturday, February 19, 2011 at 10:17 AM, Black, Michael (IS) wrote: > sqlite> create virtual table data using fts4(content text); > sqlite> insert into data values('one two'); > sqlite> insert or replace into data(content) select content||' three four' > from data where docid=1; > > The

[sqlite] FTS Append?

I think I already know the answer to this...but is it possible to append text to an FTS row without doing some sort of subselect? Even with the subselect what;s the best way to do this? I seem unable to find a single-liner that works. sqlite> create virtual table data using fts4(content