On 6 Mar 2017, at 10:01pm, Richard Hipp <d...@sqlite.org> wrote: > On 3/6/17, Simon Slavin <slav...@bigfraud.org> wrote: >> >> This means that each TRIGGER is its own little story, right ? Triggers can >> make their own inserts. Which may themselves have triggers. SQLite >> maintains a happy stack of values for last_insert_rowid(), pushing and >> popping them each time you enter or exit a trigger ? > > Correct
Thank you. I wrote one piece of code which assumed this but wasn’t sure whether it was certain in future versions. What you wrote assures me that I can assume future versions of SQLite3 will work the same way. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
