Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLAQx-0001io-7v for pgsql-committers@arkaria.postgresql.org; Thu, 26 Jan 2023 22:09:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pLAQv-0003W4-Gh for pgsql-committers@arkaria.postgresql.org; Thu, 26 Jan 2023 22:09:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLAQv-0003Vu-9m for pgsql-committers@lists.postgresql.org; Thu, 26 Jan 2023 22:09:25 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLAQs-0006oX-T9 for pgsql-committers@lists.postgresql.org; Thu, 26 Jan 2023 22:09:24 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLAQs-0006Rl-98 for pgsql-committers@lists.postgresql.org; Thu, 26 Jan 2023 22:09:22 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pLAQq-00057N-Cg for pgsql-committers@lists.postgresql.org; Thu, 26 Jan 2023 22:09:21 +0000 Content-Type: multipart/mixed; boundary="===============5685694856428223437==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve TimestampDifferenceMilliseconds to cope with overflow sa X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 26 Jan 2023 22:09:21 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5685694856428223437== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBUaW1lc3RhbXBEaWZmZXJlbmNlTWlsbGlzZWNvbmRzIHRvIGNvcGUgd2l0aCBvdmVy ZmxvdyBzYW5lbHkuCgpXZSdkIGxpa2UgdG8gdXNlIFRpbWVzdGFtcERpZmZlcmVuY2VNaWxsaXNl Y29uZHMgd2l0aCB0aGUgc3RvcF90aW1lCnBvc3NpYmx5IGJlaW5nIFRJTUVTVEFNUF9JTkZJTklU WSwgYnV0IHVwIHRvIG5vdyBpdCdzIGRpc2NsYWltZWQKcmVzcG9uc2liaWxpdHkgZm9yIG92ZXJm bG93IGNhc2VzLiAgRGVmaW5lIGl0IHRvIGNsYW1wIGl0cyBvdXRwdXQgdG8KdGhlIHJhbmdlIFsw LCBJTlRfTUFYXSwgaGFuZGxpbmcgb3ZlcmZsb3cgY29ycmVjdGx5LiAgKElOVF9NQVggcmF0aGVy CnRoYW4gTE9OR19NQVggc2VlbXMgYXBwcm9wcmlhdGUsIGJlY2F1c2UgdGhlIGZ1bmN0aW9uIGlz IGFscmVhZHkKZGVzY3JpYmVkIGFzIGJlaW5nIGludGVuZGVkIGZvciBjYWxjdWxhdGluZyB3YWl0 IHRpbWVzIGZvciBXYWl0TGF0Y2gKZXQgYWwsIGFuZCB0aGF0IGluZnJhc3RydWN0dXJlIG9ubHkg aGFuZGxlcyB3YWl0cyB1cCB0byBJTlRfTUFYLgpBbHNvLCB0aGlzIGNob2ljZSBnZXRzIHJpZCBv ZiBjcm9zcy1wbGF0Zm9ybSBiZWhhdmlvcmFsIGRpZmZlcmVuY2VzLikKCkhhdmluZyBkb25lIHRo YXQsIHdlIGNhbiByZXBsYWNlIHNvbWUgYWQtaG9jIGNvZGUgaW4gd2FscmVjZWl2ZXIuYwp3aXRo IGEgc2ltcGxlIGNhbGwgdG8gVGltZXN0YW1wRGlmZmVyZW5jZU1pbGxpc2Vjb25kcy4KCldoaWxl IGF0IGl0LCBmaXggc29tZSBidWdsZXRzIGluIGV4aXN0aW5nIGNhbGxlcnMgb2YKVGltZXN0YW1w RGlmZmVyZW5jZU1pbGxpc2Vjb25kczogYmFzZWJhY2t1cF9jb3B5LmMgaGFkIG5vdCByZWFkIHRo ZQptZW1vIGFib3V0IFRpbWVzdGFtcERpZmZlcmVuY2VNaWxsaXNlY29uZHMgbmV2ZXIgcmV0dXJu aW5nIGEgbmVnYXRpdmUKdmFsdWUsIGFuZCBwb3N0bWFzdGVyLmMgaGFkIG5vdCByZWFkIHRoZSBt ZW1vIGFib3V0IE1pbigpIGFuZCBNYXgoKQpiZWluZyBtYWNyb3Mgd2l0aCBtdWx0aXBsZS1ldmFs dWF0aW9uIGhhemFyZHMuICBOZWl0aGVyIG9mIHRoZXNlCnF1aXRlIHNlZW0gd29ydGggYmFjay1w YXRjaGluZy4KClBhdGNoIGJ5IG1lOyB0aGFua3MgdG8gTmF0aGFuIEJvc3NhcnQgZm9yIHJldmll dy4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMzEyNjcyNy4xNjc0NzU5MjQ4QHNz cy5wZ2gucGEudXMKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8zYTI4ZDc4MDg5Mjg5Nzk0ZmRhODZj ZGJkMjc1ZmM0NzU2YzZjNmFhCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFj a2VuZC9iYWNrdXAvYmFzZWJhY2t1cF9jb3B5LmMgIHwgIDMgKystCnNyYy9iYWNrZW5kL3Bvc3Rt YXN0ZXIvcG9zdG1hc3Rlci5jICAgfCAxMSArKysrKystLS0tLQpzcmMvYmFja2VuZC9yZXBsaWNh dGlvbi93YWxyZWNlaXZlci5jIHwgMTIgKysrLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2Fk dC90aW1lc3RhbXAuYyAgICAgfCAyMSArKysrKysrKysrKysrLS0tLS0tLS0KNCBmaWxlcyBjaGFu Z2VkLCAyNCBpbnNlcnRpb25zKCspLCAyMyBkZWxldGlvbnMoLSkKCg== --===============5685694856428223437==--