On 6 Mar 2017, at 10:01pm, Richard Hipp <[email protected]> wrote:

> On 3/6/17, Simon Slavin <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to