Come to think of it that should work. I was storing terms in single rows and
had to allow for duplicates. But converting to FTS relieves that as there are
two flows in the code where it knows when a record is new or old so I don't
have to worry about the "record already exists" for this case....it won't exist.
I was just starting to flesh out how to do what I need and was playing with FTS
to see if it will work for what I need.
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
________________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Puneet Kishor [punk.k...@gmail.com]
Sent: Saturday, February 19, 2011 10:21 AM
To: General Discussion of SQLite Database
Subject: EXT :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 docid=1 doesn't work the way I want and I can't seem to figure out how to
> put in an "as" clause to make it work. Should end up with just one record
> but, of course, get 2.
>
Shouldn't an UPDATE just work?
UPDATE data
SET content = content || ' three four'
WHERE docid = 1;
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
