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 1pdb2o-0000Zc-0f for pgsql-committers@arkaria.postgresql.org; Sat, 18 Mar 2023 18:12:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pdb2k-0005RO-LN for pgsql-committers@arkaria.postgresql.org; Sat, 18 Mar 2023 18:12:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pdb2k-0005RD-E2 for pgsql-committers@lists.postgresql.org; Sat, 18 Mar 2023 18:12:38 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pdb2f-0008Uy-Pc for pgsql-committers@lists.postgresql.org; Sat, 18 Mar 2023 18:12:37 +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 1pdb2d-0005hB-7n for pgsql-committers@lists.postgresql.org; Sat, 18 Mar 2023 18:12:31 +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 1pdb2c-004BMU-7K for pgsql-committers@lists.postgresql.org; Sat, 18 Mar 2023 18:12:30 +0000 Content-Type: multipart/mixed; boundary="===============3628286115794697425==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add functions to do timestamptz arithmetic in a non-default time X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 18 Mar 2023 18:12:30 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3628286115794697425== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIGZ1bmN0aW9ucyB0byBkbyB0aW1lc3RhbXB0eiBhcml0aG1ldGljIGluIGEgbm9uLWRlZmF1 bHQgdGltZXpvbmUuCgpBZGQgdmVyc2lvbnMgb2YgdGltZXN0YW1wdHogKyBpbnRlcnZhbCwgdGlt ZXN0YW1wdHogLSBpbnRlcnZhbCwgYW5kCmdlbmVyYXRlX3Nlcmllcyh0aW1lc3RhbXB0eiwgLi4u KSBpbiB3aGljaCBhIHRpbWV6b25lIGNhbiBiZSBzcGVjaWZpZWQKZXhwbGljaXRseSBpbnN0ZWFk IG9mIGRlZmF1bHRpbmcgdG8gdGhlIFRpbWVab25lIEdVQyBzZXR0aW5nLgoKVGhlIG5ldyBmdW5j dGlvbnMgZm9yIHRoZSBmaXJzdCB0d28gYXJlIG5hbWVkIGRhdGVfYWRkIGFuZApkYXRlX3N1YnRy YWN0LiAgVGhpcyBtaWdodCBzZWVtIHRvbyBnZW5lcmljLCBidXQgd2UgY291bGQgdXNlCm92ZXJs b2FkaW5nIHRvIGFkZCBhZGRpdGlvbmFsIHZhcmlhbnRzIGlmIHRoYXQgc2VlbXMgdXNlZnVsLgoK QWxvbmcgdGhlIHdheSwgaW1wcm92ZSB0aGUgZG9jcycgcHJldHR5IGluYWRlcXVhdGUgZXhwbGFu YXRpb24Kb2YgaG93IHRpbWVzdGFtcHR6ICstIGludGVydmFsIHdvcmtzLgoKUHJ6ZW15c8WCYXcg U3p0b2NoIGFuZCBHdXJqZWV0IFNpbmdoOyBjb3NtZXRpYyBjaGFuZ2VzIGFuZCBtb3N0IG9mCnRo ZSBkb2NzIHdvcmsgYnkgbWUKCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMDFhODQ1 NTEtNDhkZC0xMzU5LWJmN2UtZjZiMDIwM2E2YmQwQHN6dG9jaC5wbAoKQnJhbmNoCi0tLS0tLQpt YXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21t aXRkaWZmLzc1YmQ4NDZiNjhiMDlmMzNhNTdkOWRlOTYwNjRkZWQ0ZDM5MmNhMDUKCk1vZGlmaWVk IEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9mdW5jLnNnbWwgICAgICAgICAgICAg ICAgICAgIHwgIDkzICsrKysrKysrKysrKysrKysrLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3Rp bWVzdGFtcC5jICAgICAgICAgfCAxNDYgKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0tCnNy Yy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lvbi5oICAgICAgICAgIHwgICAyICstCnNyYy9pbmNs dWRlL2NhdGFsb2cvcGdfcHJvYy5kYXQgICAgICAgICAgIHwgIDIxICsrKysrCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvdGltZXN0YW1wdHoub3V0IHwgIDU0ICsrKysrKysrKysrCnNyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL3RpbWVzdGFtcHR6LnNxbCAgICAgIHwgIDE5ICsrKysKNiBmaWxlcyBjaGFu Z2VkLCAyOTEgaW5zZXJ0aW9ucygrKSwgNDQgZGVsZXRpb25zKC0pCgo= --===============3628286115794697425==--