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

Reply via email to