Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYlUj-00DsbE-2e for pgsql-committers@arkaria.postgresql.org; Tue, 30 Jul 2024 11:58:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sYlUg-0090hJ-Mz for pgsql-committers@arkaria.postgresql.org; Tue, 30 Jul 2024 11:58:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYlUg-0090hA-F8 for pgsql-committers@lists.postgresql.org; Tue, 30 Jul 2024 11:58:18 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYlUd-002CgH-4s for pgsql-committers@lists.postgresql.org; Tue, 30 Jul 2024 11:58:16 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYlUc-006tAU-8Y for pgsql-committers@lists.postgresql.org; Tue, 30 Jul 2024 11:58:14 +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 1sYlUb-001t2y-49 for pgsql-committers@lists.postgresql.org; Tue, 30 Jul 2024 11:58:13 +0000 Content-Type: multipart/mixed; boundary="===============8070694202930529108==" MIME-Version: 1.0 From: Andrew Dunstan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Preserve tz when converting to jsonb timestamptz X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 30 Jul 2024 11:58:13 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8070694202930529108== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UHJlc2VydmUgdHogd2hlbiBjb252ZXJ0aW5nIHRvIGpzb25iIHRpbWVzdGFtcHR6CgpUaGlzIHJl bW92ZXMgYW4gaW5jb25zaXN0ZW5jeSBpbiB0aGUgdHJlYXRtZW50IG9mIGRpZmZlcmVudCBkYXRh dHlwZXMgYnkKdGhlIGpzb25wYXRoIHRpbWVzdGFtcF90eigpIGZ1bmN0aW9uLiBDb252ZXJzaW9u cyBmcm9tIGRhdGEgdHlwZXMgdGhhdAphcmUgbm90IHRpbWVzdGFtcC1hd2FyZSwgc3VjaCBhcyBk YXRlIGFuZCB0aW1lc3RhbXAsIGFyZSBub3cgdHJlYXRlZApjb25zaXN0ZW50bHkgd2l0aCBjb252 ZXJzaW9uIGZyb20gdGhvc2UgdGhhdCBhcmUgc3VjaCBhcyB0aW1lc3RhbXB0ei4KCkF1dGhvcjog RGF2aWQgV2hlZWxlcgpSZXZpZXdlZC1ieTogSnVud2FuZyBaaGFvIGFuZCBKZWV2YW4gQ2hhbGtl CgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzdERTA4MENFLTZEOEMtNDc5NC05QkQx LTdEOTY5OTE3MkZBQiU0MGp1c3RhdGhlb3J5LmNvbQoKQmFja3BhdGNoIHRvIHJlbGVhc2UgMTcu CgpCcmFuY2gKLS0tLS0tClJFTF8xN19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dp dC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzBkNTdkYzJmOTEzN2RlNDc1MzRjYzRkYjEx NWUxODJlNDA5M2I5NDUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5k L3V0aWxzL2FkdC9qc29ucGF0aF9leGVjLmMgICAgICAgIHwgMjUgKysrKysrKysrKysrKysrKysr KysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pzb25iX2pzb25wYXRoLm91dCB8ICA0 ICsrLS0KMiBmaWxlcyBjaGFuZ2VkLCAyNyBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygtKQoK --===============8070694202930529108==--