On 20 Feb 2010, at 1:14pm, Artem Kozarezov wrote: > Also, it would be nice and intuitive if the MAX (id) and MAX (id) + 1 worked > optimally within a range!
Just out of interest, and I know that theoretically this is not an optimal statement, but have you compared this with the results of putting the '+1' in the brackets ? In other words sqlite> INSERT INTO foo SELECT MAX (id + 1) FROM foo WHERE id >= 100 AND id < 200; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users