Re: Maintaing a Last updated timestamp column using triggers

Jean-Luc Hainaut <[email protected]> Thu, 12 Mar 2020 10:51:59 +0100

Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<[email protected]>

T24gMTIvMDMvMjAyMCAwODo0NywgRGF2aWQgQmxha2Ugd3JvdGU6Cj4gSSdtIGxvb2tpbmcgZm9y
IGFuIGVhc3kgd2F5IHRvIG1haW50YWluIGEgbGFzdCB1cGRhdGVkIGNvbHVtbiBmb3IgZWFjaAo+
IHJlY29yZCBpbiBzZXZlcmFsIHRhYmxlcyBhbmQgY29uc2lkZXJpbmcgaWYgdXNpbmcgYSB0cmln
Z2VycyBpcyB2aWFibGUuCj4KPiBJIHRob3VnaHQgdGhhdCBkZWZpbmluZyBhIHRyaWdnZXIgbGlr
ZSB0aGlzIG9uIGVhY2ggdGFibGUgd291bGQgd29yawo+Cj4gQ1JFQVRFIFRSSUdHRVIgbXlfdXBk
YXRlX3RyaWdnZXIgQkVGT1JFIFVQREFURSBPTiAgTXlfdGFibGUKPiAgICBGT1IgRUFDSCBST1cg
V0hFTiBORVcubGFzdHVwZGF0ZWQgPCBPTEQuIGxhc3R1cGRhdGVkCj4gICAgQkVHSU4KPiAgICAg
ICAgVVBEQVRFIHNvbmcgU0VUICBsYXN0dXBkYXRlZCA9IERBVEVUSU1FKCdub3cnKSBXSEVSRSBp
ZCA9IE5FVy5pZAo+ICAgIEVORAoKQXMgZmFyIGFzIEkga25vdywgdXBkYXRpbmcgdGhlIGN1cnJl
bnQgcm93IGluIGEgImJlZm9yZSIgdHJpZ2dlciBpcyBhIAoibm9wIiBpbiBTUUxpdGUgc2luY2Ug
dGhpcyByb3cgZG9lcyBub3QgZXhpc3QgeWV0IChmb3IgbXkgaW5mb3JtYXRpb24sIApjb3VsZCB5
b3UgY2hlY2s/KS4gSG93ZXZlciwgdGhpcyB3b3JrcyBmaW5lIGluIGFuICJhZnRlciIgdHJpZ2dl
ci4KCkluIGFkZGl0aW9uLCB0aGUgcm9sZSBvZiB0aGUgIndoZW4iIGNsYXVzZSBpcyB1bmNsZWFy
LiAgSXMgaXQgbmVjZXNzYXJ5PwoKSkxICgoKLS0gCkwnYWJzZW5jZSBkZSB2aXJ1cyBkYW5zIGNl
IGNvdXJyaWVyIMOpbGVjdHJvbmlxdWUgYSDDqXTDqSB2w6lyaWZpw6llIHBhciBsZSBsb2dpY2ll
bCBhbnRpdmlydXMgQXZhc3QuCmh0dHBzOi8vd3d3LmF2YXN0LmNvbS9hbnRpdmlydXMKCl9fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCnNxbGl0ZS11c2VycyBt
YWlsaW5nIGxpc3QKc3FsaXRlLXVzZXJzQG1haWxpbmdsaXN0cy5zcWxpdGUub3JnCmh0dHA6Ly9t
YWlsaW5nbGlzdHMuc3FsaXRlLm9yZy9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vc3FsaXRlLXVz
ZXJzCg==