Pavel, What will happen if you had an index on the other_column for the select/update you mentioned below? Is it just that your tree will be unbalanced every time you change the other_column? Could there be any other consequences like unpredictable behavior and such? Thanks
> Exactly this sequence is safe. Things can go nuts in case if you have > index on other_column and you do something like this: > > for value in "SELECT main_column IN mytable WHERE > other_column='something'": > UPDATE mytable SET other_column='foobar' WHERE main_column=value > > Pavel > -- View this message in context: http://old.nabble.com/UPDATE-during-SELECT-tp30253771p30284918.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users