> I don't know. Have you run an experiment to see for yourself? > Yes, but my results are inconclusive.
Currently, i am doing this: drop table idlookup;create temp table idlookup as select id from (select statement for temporary result set) Thus the statement is shorter than create temp table if not exists idlookup (id integer);insert into idlookup id=select id from (select statement for temporary result set) My thought was that by using "replace" after the table has been created, i could simply expand it (if there are more results than used to be in the table). This is all fine for that case, but if the new result set has LESS results than the previous one, then I end up with a temporary table holding the new result set and leftovers from the previous one... -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users