Re: Maintaing a Last updated timestamp column usin g triggers
"Ling, Andy" <[email protected]> Thu, 12 Mar 2020 09:59:15 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
Pk9uIDEyLzAzLzIwMjAgMDg6NDcsIERhdmlkIEJsYWtlIHdyb3RlOg0KPj4gSSdtIGxvb2tpbmcg Zm9yIGFuIGVhc3kgd2F5IHRvIG1haW50YWluIGEgbGFzdCB1cGRhdGVkIGNvbHVtbiBmb3IgZWFj aCANCj4+IHJlY29yZCBpbiBzZXZlcmFsIHRhYmxlcyBhbmQgY29uc2lkZXJpbmcgaWYgdXNpbmcg YSB0cmlnZ2VycyBpcyB2aWFibGUuDQo+Pg0KPj4gSSB0aG91Z2h0IHRoYXQgZGVmaW5pbmcgYSB0 cmlnZ2VyIGxpa2UgdGhpcyBvbiBlYWNoIHRhYmxlIHdvdWxkIHdvcmsNCj4+DQo+PiBDUkVBVEUg VFJJR0dFUiBteV91cGRhdGVfdHJpZ2dlciBCRUZPUkUgVVBEQVRFIE9OICBNeV90YWJsZQ0KPj4g ICAgRk9SIEVBQ0ggUk9XIFdIRU4gTkVXLmxhc3R1cGRhdGVkIDwgT0xELiBsYXN0dXBkYXRlZA0K Pj4gICAgQkVHSU4NCj4+ICAgICAgICBVUERBVEUgc29uZyBTRVQgIGxhc3R1cGRhdGVkID0gREFU RVRJTUUoJ25vdycpIFdIRVJFIGlkID0gTkVXLmlkDQo+PiAgICBFTkQNCg0KLi4uDQoNCj4gSW4g YWRkaXRpb24sIHRoZSByb2xlIG9mIHRoZSAid2hlbiIgY2xhdXNlIGlzIHVuY2xlYXIuICBJcyBp dCBuZWNlc3Nhcnk/DQoNCkkgZG9uJ3QgdGhpbmsgaXQgaXMuIEkgaGF2ZSBhIHZlcnkgc2ltaWxh ciB0cmlnZ2VyIHdoaWNoIEkndmUgYmVlbiB1c2luZyBmb3Igc2V2ZXJhbCB5ZWFycw0KQW5kIGl0 IGRvZXNuJ3QgaGF2ZSB0aGUgd2hlcmUuLi4NCg0KQ1JFQVRFIFRSSUdHRVIgW1VwZGF0ZVBvcnRU aW1lXSBBRlRFUiBVUERBVEUgT04gcG9ydHMNCiBGT1IgRUFDSCBST1cNCiBCRUdJTg0KICAgVVBE QVRFIHBvcnRzIFNFVCB0aW1lb2ZkYXkgPSBDVVJSRU5UX1RJTUVTVEFNUCBXSEVSRSBpZCA9IE5F Vy5pZCA7DQogRU5EDQoNCkFuZHkNCg0KCioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioKRElTQ0xBSU1FUjoKUHJpdmls ZWdlZCBhbmQvb3IgQ29uZmlkZW50aWFsIGluZm9ybWF0aW9uIG1heSBiZSBjb250YWluZWQgaW4g dGhpcyBtZXNzYWdlLiBJZiB5b3UgYXJlIG5vdCB0aGUgYWRkcmVzc2VlIG9mIHRoaXMgbWVzc2Fn ZSwgeW91IG1heSBub3QgY29weSwgdXNlIG9yIGRlbGl2ZXIgdGhpcyBtZXNzYWdlIHRvIGFueW9u ZS4gSW4gc3VjaCBldmVudCwgeW91IHNob3VsZCBkZXN0cm95IHRoZSBtZXNzYWdlIGFuZCBraW5k bHkgbm90aWZ5IHRoZSBzZW5kZXIgYnkgcmVwbHkgZS1tYWlsLiBJdCBpcyB1bmRlcnN0b29kIHRo YXQgb3BpbmlvbnMgb3IgY29uY2x1c2lvbnMgdGhhdCBkbyBub3QgcmVsYXRlIHRvIHRoZSBvZmZp Y2lhbCBidXNpbmVzcyBvZiB0aGUgY29tcGFueSBhcmUgbmVpdGhlciBnaXZlbiBub3IgZW5kb3Jz ZWQgYnkgdGhlIGNvbXBhbnkuIFRoYW5rIFlvdS4KX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxpdGUtdXNl cnNAbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3Jn L2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK