Re: Maintaing a Last updated timestamp column using triggers

David Blake <[email protected]> Thu, 12 Mar 2020 09:08:29 +0000
Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<CAHdQWy3-FjUpa00jcGnxTrDuqQLJ_177OWx_NNF-06ZUY9P7Wg@mail.gmail.com>
SGEsIG15IGVycm9yIC0gbWlzc2luZyAiOyIgaW4gdGhlIFVQREFURSBjbGF1c2UgYnV0IEkgd2Fz
IGJsaW5kLgoKT24gVGh1LCAxMiBNYXIgMjAyMCBhdCAwODoxOCwgRGF2aWQgQmxha2UgPGRhdmVi
bGFrZUBrb2RpLnR2PiB3cm90ZToKCj4gVGhhbmtzIGZvciBzdWNoIGEgc3dpZnQgcmVwbHksIGdv
b2QgdG8ga25vdyB0aGF0IGl0IHNob3VsZCB3b3JrICh3aXRob3V0Cj4gdHlwb3MpCj4KPiA+VGhh
bmsgeW91IHZlcnkgbXVjaCBmb3Iga2VlcGluZyB0aGUgZXJyb3IgbWVzc2FnZSBzZWNyZXQuCj4K
PiBuZWFyICJFTkQiOiBzeW50YXggZXJyb3I6Cj4KPgo+IEknbSB0ZXN0aW5nIG91dCBpZGVhcyB1
c2luZyBEQiBCcm93c2VyLCBidXQgd2lsbCB0cnkgaW4gbXkgYXBwIGFuZCBzZWUgaWYKPiB0aGlz
IGlzIGp1c3QgYSBEQiBCcm93c2VyIGlzc3VlCj4KPiBPbiBUaHUsIDEyIE1hciAyMDIwIGF0IDA4
OjA0LCBDbGVtZW5zIExhZGlzY2ggPGNsZW1lbnNAbGFkaXNjaC5kZT4gd3JvdGU6Cj4KPj4gRGF2
aWQgQmxha2Ugd3JvdGU6Cj4+ID4gQ1JFQVRFIFRSSUdHRVIgbXlfdXBkYXRlX3RyaWdnZXIgQkVG
T1JFIFVQREFURSBPTiAgTXlfdGFibGUKPj4gPiAgIEZPUiBFQUNIIFJPVyBXSEVOIE5FVy5sYXN0
dXBkYXRlZCA8IE9MRC4gbGFzdHVwZGF0ZWQKPj4gPiAgIEJFR0lOCj4+ID4gICAgICAgVVBEQVRF
IG15X3RhYmxlU0VUICBsYXN0dXBkYXRlZCA9IERBVEVUSU1FKCdub3cnKSBXSEVSRSBpZCA9Cj4+
IE5FVy5pZAo+PiA+ICAgRU5ECj4+ID4KPj4gPiBUaGUgV0hFTiBjbGF1c2UgaXMgYW4gYXR0ZW1w
dCB0byBhdm9pZCBpbmZpbml0ZSByZWN1cnNpb24gdGhhdCBVUERBVEUKPj4gPiB3aXRoaW4gYW4g
VVBEQVRFIHdvdWxkIGNhdXNlLgo+Pgo+PiBUeXBpY2FsIFVQREFURSBzdGF0ZW1lbnRzIHdpbGwg
bGVhdmUgdGhpcyBmaWVsZCB3aXRoIGl0cyBvbGQgdmFsdWUsIHNvCj4+IGl0IG1pZ2h0IGJlIGEg
YmV0dGVyIGlkZWFzIHRvIHVzZSA8PSBpbnN0ZWFkIG9mIDwuCj4+Cj4+ID4gSG93ZXZlciBJIGdl
dCBTUUwgZXJyb3JzIHdoZW4gSSB0cnkgZGVmaW5pbmcgYSB0cmlnZ2VyIHRoaXMgd2F5IHRoaXMK
Pj4gPiBpbiBteSBmYXZvcml0ZSBkYiBkYnJvd3Nlci4KPj4KPj4gVGhhbmsgeW91IHZlcnkgbXVj
aCBmb3Iga2VlcGluZyB0aGUgZXJyb3IgbWVzc2FnZSBzZWNyZXQuCj4+Cj4+IFdoZW4gSSBmaXgg
dGhlIHdyb25nIHRhYmxlIHRhYmxlIG5hbWUgYW5kIGFkZCB0aGUgbWlzc2luZyBzZW1pY29sb24g
YWZ0ZXIKPj4gdGhlIFVQREFURSBzdGF0ZW1lbnQsIHRoaXMgdHJpZ2dlciB3b3JrcyBmaW5lLgo+
Pgo+Pgo+PiBSZWdhcmRzLAo+PiBDbGVtZW5zCj4+IF9fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fCj4+IHNxbGl0ZS11c2VycyBtYWlsaW5nIGxpc3QKPj4gc3Fs
aXRlLXVzZXJzQG1haWxpbmdsaXN0cy5zcWxpdGUub3JnCj4+IGh0dHA6Ly9tYWlsaW5nbGlzdHMu
c3FsaXRlLm9yZy9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vc3FsaXRlLXVzZXJzCj4+Cj4KX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJz
IG1haWxpbmcgbGlzdApzcWxpdGUtdXNlcnNAbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDov
L21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUt
dXNlcnMK