Re: Maintaing a Last updated timestamp column using triggers

David Blake <[email protected]> Thu, 12 Mar 2020 15:36:32 +0000

Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<CAHdQWy0YnSk_CWzqQpAtBR4KT8TgfSsoXHtB3bFoE+CNCSUwZw@mail.gmail.com>

VGhhbmtzIEFuZHkKCj4gSW4gYWRkaXRpb24sIHRoZSByb2xlIG9mIHRoZSAid2hlbiIgY2xhdXNl
IGlzIHVuY2xlYXIuICBJcyBpdCBuZWNlc3Nhcnk/Cj4KPiBJIGRvbid0IHRoaW5rIGl0IGlzLiBJ
IGhhdmUgYSB2ZXJ5IHNpbWlsYXIgdHJpZ2dlciB3aGljaCBJJ3ZlIGJlZW4gdXNpbmcKPiBmb3Ig
c2V2ZXJhbCB5ZWFycwo+IEFuZCBpdCBkb2Vzbid0IGhhdmUgdGhlIHdoZXJlLi4uCj4KPiBDUkVB
VEUgVFJJR0dFUiBbVXBkYXRlUG9ydFRpbWVdIEFGVEVSIFVQREFURSBPTiBwb3J0cwo+ICBGT1Ig
RUFDSCBST1cKPiAgQkVHSU4KPiAgICBVUERBVEUgcG9ydHMgU0VUIHRpbWVvZmRheSA9IENVUlJF
TlRfVElNRVNUQU1QIFdIRVJFIGlkID0gTkVXLmlkIDsKPiAgRU5ECj4KCldoYXQgc3RvcHMgdGhl
ClVQREFURSBwb3J0cyBTRVQgdGltZW9mZGF5ID0gQ1VSUkVOVF9USU1FU1RBTVAgV0hFUkUgaWQg
PSBORVcuaWQgOwpmcm9tIGFsc28gdHJpZ2dlcmluZyB0aGUgQUZURVIgVVBEQVRFIE9OIHJlY3Vy
c2l2ZWx5PwoKUGVyaGFwcyBhIHByYWdtYSBvciBpblNRTGl0ZSBhcmUgIHRyaWdnZXJzIG5vbi1y
ZWN1cnNpdmUgYnkgZGVmYXVsdD8KCkkgYW0gdXNpbmcgKG5vdyBJIGhhdmUgYnkgc2VtaS1jb2xv
bnMgcmlnaHQpCkNSRUFURSBUUklHR0VSIHRnclVwZGF0ZSBBRlRFUiBVUERBVEUgT04gbXlUYWJs
ZSBGT1IgRUFDSCBST1cKV0hFTiBORVcuTGFzdFVwZGF0ZSA8PSBPTEQuIExhc3RVcGRhdGUKQkVH
SU4KVVBEQVRFIG15VGFibGUgU0VUICBMYXN0VXBkYXRlID0gREFURVRJTUUoJ25vdycpIFdIRVJF
IGlkID0gT0xELmlkOwpFTkQKCk15IGludGVudGlvbiBpcyBmb3IgdGhlIHdoZW4gdG8gYXZvaWQg
aW5maW5pdGUgY2FsbHMsIGJ1dCBtYXliZSBJIGFtCmZvb2xpbmcgbXlzZWxmLgpfX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpzcWxpdGUtdXNlcnMgbWFpbGlu
ZyBsaXN0CnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwpodHRwOi8vbWFpbGlu
Z2xpc3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS11c2Vycwo=