Re: CLSQL Wall-Time - Timestamptz vs Timestamp issues
Russ Tyndall <[email protected]> Wed, 7 Feb 2018 11:47:11 -0500
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
ID4+IEkgZmVlbCBsaWtlIHlvdXIgcXVlc3Rpb24gaXMgZGlzaW5nZW51b3VzLAoKPiBvbiB0aGUg Y29udHJhcnkuIGl0IGNvbWVzIGZyb20gc2V2ZXJhbCBkZWNhZGVzIG9mIHJ1bm5pbmcgc2VydmVy cyB3aGljaAo+IGNvbXByaXNlIHRlbXBvcmFsIG1vZGVscy4KCkFwb2xvZ2llcywgeW91IHNlZW1l ZCB0byBiZSBkZW55aW5nIHRoYXQgaXQgd2FzIHBvc3NpYmxlIHRvIGhhdmUgdG8gZGVhbAp3aXRo IHpvbmVsZXNzIHRpbWVzIC0gd2hpY2ggZ2l2ZW4gdGhlaXIgZXhpc3RlbmNlIGluIHRoZSBzdGFu ZGFyZCBzZWVtZWQKYSBkaXNpbmdlbnVvdXMgYXJndW1lbnQuCgo+IGV2ZW4gaWYgeW91IGRvIGRp c3Rpbmd1aXNoLCB1bmxlc3MgdGhlcmUgaXMgYSBzb3VyY2UgZm9yIHRoZSB0aW1lem9uZSwgCj4g eW91ciBvcHRpb25zIGFyZSBsaW1pdGVkLgoKQXQgbGVhc3QgSSBoYXZlIHRoZSBvcHRpb24gb2Yg ZWl0aGVyIHNpZ25hbGluZyBhbiBlcnJvciBvciBjaG9vc2luZyBhbgppbnRlcnByZXRhdGlvbiAo ZWc6IHV0YyBvciBsb2NhbHRpbWUpIHZzIHNpbGVudCBmYWlsdXJlLgoKTWFueSBvZiB0aGUgInBy b2R1Y3Rpb24iIGRhdGFiYXNlcyBJIGVuZCB1cCBoYXZpbmcgdG8gd29yayBvbiBhcmUgb3BlcmF0 ZWQKaW4gc21hbGwgY29tcGFuaWVzIHdoZXJlIGFsbCBkYXRhIGlzIGxvY2FsIHRvIGEgc2luZ2xl IHRpbWV6b25lLiAgSW4gbXkKeWVhcnMgb2YgY29uc3VsdGluZyBvbiB2YXJpb3VzIGRhdGFiYXNl cywgaXQgc2VlbXMgbW9yZSBjb21tb24gdGhhdCB0aGluZ3MKYXJlIHB1dCB0b2dldGhlciByYXRo ZXIgcG9vcmx5LiAgVGhpcyBjb3VsZCBiZSB3aHkgdGhleSBuZWVkIGEgY29uc3VsdGFudAp0aG91 Z2ggKHNrZXdpbmcgbXkgcGVyc3BlY3RpdmUpLgoKSWYgeW91IGhhdmUgYSBwbGFuIGZvciBob3cg dGhlIGRhdGFiYXNlIGxheWVyIGNhbiBzdXBwb3J0IHpvbmVsZXNzIHZzIHpvbmVkCnRpbWVzLCB3 aXRob3V0IHRyYWNraW5nIHRoYXQgaW5mb3JtYXRpb24sIEkgd291bGQgYmUgaGFwcHkgdG8gaGVh ciBpdC4gIEkKd291bGQgd2FudCB0aGUgc29sdXRpb24gdG8gc3VwcG9ydCBlaXRoZXIgaW50ZXJw cmV0YXRpb24gb2YgYSB6b25lbGVzcyB0aW1lLgooVGhpcyBwYXRjaCBkb2VzIGFsbG93IGVpdGhl ciwgYXMgeW91IGNhbiBlaXRoZXIgY29udmVydCB0byB1dGMsIG9yIHNpbXBseQpzZXQgdGhhdCB0 aGUgY3VycmVudCB0aW1lIElTIHV0YykuCgpUaGUgcHJvYmxlbSB0aGF0IGV4cGxpY2l0bHkgbWFk ZSBtZSBpbnZlc3RpZ2F0ZSB0aGlzIGlzIHRoYXQgem9uZWxlc3MgdGltZXMKd2VyZSBiZWluZyB3 cml0dGVuIHRvIHBvc3RncmVzLCBmb3IgZmllbGRzIGFzc3VtZWQgdG8gYmUgVVRDLCBjYXVzaW5n IHRoZQp6b25lbGVzcyB0aW1lIHRvIGJlIHRyZWF0ZWQgYXMgbG9jYWwgb24gaW5zZXJ0L3VwZGF0 ZSBhbmQgcmVjb252ZXJ0ZWQgdG8gVVRDCihieSBwb3N0Z3JlcykuIEkgY291bGQgaGF2ZSBkb25l IHRoZSBvcHBvc2l0ZSwgYWx3YXlzIHdyaXRlIFVUQyB0aW1lcywgYnV0CnRoYXQgd2lsbCBiZSB0 aGUgd3JvbmcgaW50ZXJwcmV0YXRpb24gZm9yIHNvbWUgYXBwbGljYXRpb25zLgoKSW4gdGhpcyBw YXRjaCBJIGNob3NlIHRvIHRyZWF0IHpvbmVsZXNzIHRpbWVzIHRoZSBzYW1lIHdheSBjb21tb24g bGlzcCBkb2VzLAphcyBsb2NhbCB0aW1lcy4gIEkgbGV0IHRoZSBpbXBsZW1lbnRhdGlvbiBwcm92 aWRlIGEgZGVmYXVsdCB0aW1lem9uZSBmb3IgdGhlCnpvbmVsZXNzIHRpbWUgYW5kIGNvbnZlcnQg dG8gVVRDIGFzIG5lZWRlZCBmb3IgY29tcGFyaXNvbi4gV2hpY2ggc2VlbWVkCnJlYXNvbmFibGUg Z2l2ZW4gdGhlIG9wdGlvbnMgYW5kIGFsbG93cyBmb2xrcyB0byBjb250cm9sIHRoZSBiZWhhdmlv ciBmcm9tCnRoZWlyIGFwcGxpY2F0aW9uLgoKQ2hlZXJzLApSdXNzIFR5bmRhbGwKQWNjZWxlcmF0 aW9uLm5ldAoKCgoKCgoKCk9uIDAyLzA3LzIwMTggMTE6MDkgQU0sIGphbWVzIGFuZGVyc29uIHdy b3RlOgo+IGdvb2QgZXZlbmluZzsKPgo+PiBPbiAyMDE4LTAyLTA3LCBhdCAxNjowNiwgUnVzcyBU eW5kYWxsIDxydXNzQGFjY2VsZXJhdGlvbi5uZXQ+IHdyb3RlOgo+Pgo+PiAuLi4KPj4KPj4+IFdo YXQgaXMgdGhlIGFjdHVhbCBiZW5lZml0Pwo+PiAuLi4KPj4KPj4gQXMgYSBkaXJlY3QgZXhhbXBs ZTogd2hhdCBpcyB0aGUgY29ycmVjdCB3YXksIGluIGNvbW1vbiBsaXNwLCB0bwo+PiBjb21wYXJl IHRoZSByZXN1bHRzIG9mIGEgdGltZXN0YW1wIHF1ZXJpZWQgZnJvbSB0aGUgZGF0YWJhc2UgKGhh cyBubwo+PiB6b25lIGluZm9ybWF0aW9uKSBhbmQgYSB0aW1lc3RhbXB0eiAoaXMgaW4gVVRDKS4g WW91IGNhbiBzYXkgIm5vIG9uZQo+PiBzaG91bGQgdXNlIHRpbWVzdGFtcCIsIG9yICJ0aGF0cyB1 bmRlZmluZWTigJ0sCj4geWVzLCBpZiB0aGVyZSBpcyBubyBhZGRpdGlvbmFsIGRhdGEgd2hpY2gg c3BlY2lmaWVzIHRoZSB0aW1lIHpvbmUgdGhlbiB0aGUgZGVmaW5lZCBjb21wYXJpc29uIG9wZXJh dGlvbnMgYXJlIGxpbWl0ZWQuCj4KPj4gYnV0IHdpdGhvdXQKPj4gZGlzdGluZ3Vpc2hpbmcgYmV0 d2VlbiB0aGUgdHdvIHN0YXRlICh6b25lbGVzcywgYW5kIFVUQykgeW91IGNhbm5vdAo+PiBhY3R1 YWxseSBjaG9vc2Ugd2hhdCBoYXBwZW5zIG9yIGV2ZW4gc2F5IHRoYXQgaXQgaXMgdW5kZWZpbmVk IC0geW91Cj4+IGhhdmUgbG9zdCB0aGUgaW5mb3JtYXRpb24gdGhhdCBvbmUgY2FtZSB6b25lbGVz cyBhbmQgb25lIGluIFVUQy4KPiBldmVuIGlmIHlvdSBkbyBkaXN0aW5ndWlzaCwgdW5sZXNzIHRo ZXJlIGlzIGEgc291cmNlIGZvciB0aGUgdGltZXpvbmUsIHlvdXIgb3B0aW9ucyBhcmUgbGltaXRl ZC4KPgo+PiBBbm90aGVyIGV4YW1wbGU6IGEgY3N2IGltcG9ydCBoYXMgZGF0dW0gIjIwMTYtMDEt MDEgMDk6NTg6MzciIGJlaW5nCj4+IGNvcGllZCB0byBib3RoIGEgdGltZXN0YW1wIGFuZCBhIHRp bWVzdGFtcHR6IGZpZWxkLiAoU2F5IGEgZGF0YSBpbnRlcm4KPj4gdXNlZCBDT1BZIHRvIHB1dCB0 aGlzIGRpcmVjdGx5IGludG8gc29tZSBuZXcgdGVtcCB0YWJsZXMgaW4gdGhlCj4+IGRhdGFiYXNl KS4KPiB1bmxlc3MgeW91IGhhdmUgcmVjb3JkZWQgdGhlIHRpbWV6b25lIGluZm9ybWF0aW9uIHNv bWV3aGVyZSB3aGljaCByZW1haW5zIGFzc29jaWF0ZWQgd2l0aCB0aGUgcmVjb3JkLCB0byBwZXJt aXQgYW4gYXBwbGljYXRpb24gdG8gcmVjb25zdGl0dXRlIHRoZSB0ZW1wb3JhbCBsb2NhdGlvbiwg dGhlIHVuLXpvbmVkIHRpbWUgaGFzIGJlZW4gdHJhbnNmb3JtZWQgaW50byBhbiBpbnRlcnZhbC4K PiB0aGVyZSBhcmUgc29tZSBvcGVyYXRpb25zIHdoaWNoIGFyZSB2YWxpZCBmb3IgdGhhdCBkYXRh IHR5cGUsIGJ1dCBwcm9iYWJseSBub3QgYWxsIG9mIHRob3NlIHdoaWNoIG9uZSB3b3VsZCBsaWtl Lgo+Cj4+IE5vdyBJIGhhdmUgdG8gZG8gc29tZSBjYWxjdWxhdGlvbnMgYmFzZWQgb24gdGhhdCwg YnV0IHVwb24KPj4gcXVlcnlpbmcgdGhpcyBkYXRhIGZyb20gdGhlIHRpbWVzdGFtcCBmaWVsZCBJ IGdldCAiMjAxNi0wNy0wMSAwOTo1ODozNyIKPj4gYW5kIGZyb20gdGhlIHRpbWVzdGFtcHR6IGZp ZWxkIEkgZ2V0ICIyMDE2LTA3LTAxIDExOjU4OjM3IiB3aXRoIG5vIExJU1AKPj4gaW5kaWNhdG9y IHRoYXQgdGhlc2UgYXJlIGRpZmZlcmVudCB0aW1lc3RhbXBzLgo+Pgo+IGJlc3QgcmVnYXJkcywg ZnJvbSBiZXJsaW4sCj4KPiAtLS0KPiBqYW1lcyBhbmRlcnNvbiB8IGphbWVzQGR5ZHJhLmNvbSB8 IGh0dHA6Ly9keWRyYS5jb20KPgo+Cj4KPgo+Cj4KPiBfX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXwo+IENMU1FMIG1haWxpbmcgbGlzdAo+IENMU1FMQGxpc3Rz LmtwZS5pbwo+IGh0dHA6Ly9saXN0cy5rcGUuaW8vY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL2Ns c3FsCgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpDTFNR TCBtYWlsaW5nIGxpc3QKQ0xTUUxAbGlzdHMua3BlLmlvCmh0dHA6Ly9saXN0cy5rcGUuaW8vY2dp LWJpbi9tYWlsbWFuL2xpc3RpbmZvL2Nsc3FsCg==