On Wed, Mar 09, 2011 at 11:19:51PM +0100, Armin Kunaschik scratched on the wall:
> Important: I also want to be able to "insert or replace" rows and keep ctime. > The update trigger works fine, but the insert trigger ALWAYS updates ctime. As Igor pointed out, "INSERT OR REPLACE" is called "INSERT OR **REPLACE**" not "INSERT OR UPDATE." The old row is completely DELETEed before the new row is INSERTed. There is no UPDATE in a INSERT OR REPLACE. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users