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 1u9eS5-004TSM-DU for pgsql-novice@arkaria.postgresql.org; Tue, 29 Apr 2025 06:28:22 +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 1u9eS2-005OOI-NT for pgsql-novice@arkaria.postgresql.org; Tue, 29 Apr 2025 06:28:19 +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 1u9eS2-005OOA-5B for pgsql-novice@lists.postgresql.org; Tue, 29 Apr 2025 06:28:19 +0000 Received: from mail-japaneastazolkn19010014.outbound.protection.outlook.com ([52.103.43.14] helo=TY3P286CU002.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u9eS0-00088A-1E for pgsql-novice@lists.postgresql.org; Tue, 29 Apr 2025 06:28:18 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=Cvv/JfAMqs/I//TZEuR8ycNg+VoUcyX1BTSRh3IrkYTCA7KDXxYaAHWmMWZ9PJOWQ/JtVj9gJ353uDmSQmn/W/js9Vc80H1+RHiqTraZMq8QC8qyLXvUAZB4+CmVreJQPOOHiUeIsflaWP+x/aazYruVO8krA7adbzmNUQ/07dje6KKZfnWc1UJLyyzpHg4BIsT1jt/Cbt4U8EvHeQC7kY6dfK5WUXps/jFj2IyinA7gqNGq3KFIJolFHKqhstuGtdN9Pbjcu4IHhdyWCLakCvqJUAU4R5SXSL//Cto0BvmUFP2zAopHxV06vwbLxovIuYuuTevDyYOGfzzApUUMQQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=CpFxX+W4q64/DULfSL33I+IUG61//jmRYtE1JrgUZ74=; b=EyTttI6YkFjDy/BzdHE0YBtCQBvxY9mBnAvBzxRGeeG3GJHdhiWdoDibCxnnrKHXBjHaxwgTbOWvSTUQK4EPCByg7oH6dTlJM/ZhFW3/ZU/DkMOlQhhL3WnPStD4+dM8wn1vXM8OOAyk2KzIBjHpe6yU9Efew4Iip0fwHQ4LMtR1PTNUEGLnkNsL491pvDrb8nLOk/FNtl94dIvzRZE3Zq4KftgbDJlkgfMiEIlNL5OJCgkw9QlyhClKvMI4+m5Tg9GYyT8rGwnR2qVwL60/5l2kL/dXW7SgESoVezr2mlBnZqNTOWCoJ+/CMo/StzeKrBNDRIvAI0Y2HzgujmlhPg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=live.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=CpFxX+W4q64/DULfSL33I+IUG61//jmRYtE1JrgUZ74=; b=Es3pBFYmeKBpmGCV8YBM4YBknku/ZJRiszHvhbns6FqepnUyV/PXF7ULTNw0g9MnGFN1MR4/N/6qA0837Xw3wRypCiuUSG2N5yPKSCPkc7NHp7HMXpEY9Qi6eiWTIb17/mQ/FsNKbLTdHoLEqXyG9y2rYAWT4CnjQ4+5pwo4jpWot9CM5U3GQa0onfppIOKKtobFAwftUwS1ityxV5l08Hkibg8CHsSW1jBLgqEoe6ttCCLXE0DNjzkILHSS5TBRPCdaYUlx3WKkJxSC2CktivUJSqeLTrmJxW+9tYfLWrgXE005h78UNpDwSEVksFfOBF4kqTXpOqfh5sfpMK8WGg== Received: from OSBPR01MB2997.jpnprd01.prod.outlook.com (2603:1096:604:1a::16) by TYCPR01MB6802.jpnprd01.prod.outlook.com (2603:1096:400:b1::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8678.33; Tue, 29 Apr 2025 06:28:07 +0000 Received: from OSBPR01MB2997.jpnprd01.prod.outlook.com ([fe80::55da:98c8:7469:b8f5]) by OSBPR01MB2997.jpnprd01.prod.outlook.com ([fe80::55da:98c8:7469:b8f5%3]) with mapi id 15.20.8678.028; Tue, 29 Apr 2025 06:28:07 +0000 From: H Witt To: Bruce Momjian CC: "pgsql-novice@lists.postgresql.org" Subject: =?gb2312?B?u9i4tDogd2h5IGF0IHRpbWUgem9uZSB0el9vZmZzZXQgbm90IGVxdWFsIHR6?= =?gb2312?B?X25hbWU/ICB0el9uYW1lIGhhcyBzYW1lIG9mZnNldCBpbiBwZ190aW1lem9u?= =?gb2312?Q?e=5Fnames?= Thread-Topic: why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names Thread-Index: AQHbt+g2neMFZVGh20moEyOG9cP6I7O58DwQgAAIPACAADZNeg== Date: Tue, 29 Apr 2025 06:28:05 +0000 Message-ID: References: In-Reply-To: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OSBPR01MB2997:EE_|TYCPR01MB6802:EE_ x-ms-office365-filtering-correlation-id: 407f9aab-6e1d-4620-6099-08dd86e70041 x-ms-exchange-slblob-mailprops: 3tqGmd+bMX7GtX8MxQSRTg0xOs3U3z8VDrSXGQXbfyIGr+B1GNU+xTLddz4jiFmtCeKz8VJKM5/zgs94d9zuTZWXTNMtu659yWqUHbhHwd9HTdINXu/H6CxEkwojNAbChbTOeEb8V5vqgn555iI1n1vSJbGX85DMXcJL9N/ND66EM1sEJJEBiYUoz36VdDMeGipFxWTxleGlDCeno/kEiPoeeIb0D7GFTegwqRAieyVcYmK4fpBceVgvJSuyVJYOdyYLeEiB+2zNE+/Id0Q7n/2ONedY0CgW8tjlFmZUrtLunr8ELHdw/E4l6aW63Z/g09Yr0abT7xGhl+iJfHdw60cUApawXwbP+3huCqZCEy7PJvQOX6bs9VskkFDgqutCx9kQwbv5RZOqECU3/P8Hf5Z96QoVP6AsVJqTD7mgd4gAdpXftdGDjEdRYJLwBSLNaefBVGsbnL6OWx96h2/CbyG9Ph1CName1M0963k3i0y/ySYwKKxUaVAhKO6Fa0yzcOyfcUJHQ1u8CsE5QFrxDqrfE2GmKAIdn7ZLEPbZ6TikciC5HNpJ/Oev5jNEN60hKiViFcRW3GCM4StEe1kHvtUlCuvueR2dP7CeF67Wj4JKpCyBtSjPSZOWl5ZqRUC1zUxWviYMd/zNwLhfmqcCF4nnuOrxW15gfeGUxAOEbHBq34cEPBCe9uMAdqdE0B2HWouWP6zIepD2KrZPsqb/wWRodsErW4+3f2Wh6X6xtZCcyxqVaUtlqACbQpiyloc2yipN7BnTZMcfmR1Roh9SgrKgohEU6W3P9gaky/y5b88rOuKG0CkEYCLUYwUrM0wh3AuIDgjbfzWnzbUXCmGWkH6owyLXweBk5CQJF+ZN5+9YSCLltIAFLNCTuVGX22Zq6I/oqEB9e08O6DyUDPmgOzkn0JR/orsfPyN6xl54J74p/3IiVemv6QuAwTqLnfB2 x-microsoft-antispam: BCL:0;ARA:14566002|15030799003|7092599003|12121999004|15080799006|12050799009|8062599003|461199028|8060799006|19110799003|9400799030|440099028|10035399004|3412199025|3430499032|102099032; x-microsoft-antispam-message-info: =?gb2312?B?RmVITVZTZ0tXb0twNEEzR3VEUDJvbUpMRHBHUWdzalZkNXU2MExuQlh6MnZQ?= =?gb2312?B?M0ltd0hlc29nOEp1SzRkYjdleFNQa2YvWDh1REwrcXpBTFluNVU5Njh4Z20y?= =?gb2312?B?Nng0b0hqdmwrV3pTZnYwb1hHQ093cjNEbE8zVnlXejhqdVFVaDdqckp2YnNF?= =?gb2312?B?aDJDcDFvMkpPc2JmaHdmbTcxWHoxbGJMTitxNDExVHRFYldKYTRCRlNDV2pP?= =?gb2312?B?QU5GaVhDU0s4UnFvdGVSaU9VSlpXb2JBcWlwV1lNaXZJU2pzSGdCbnNkVEtk?= =?gb2312?B?VWdVVDVuUTV3aVFrbUtwbnRHakNTdEM5Z0ZkVVlaRTFHNjZHbUJoVnh1Rkho?= =?gb2312?B?OTN6SlFEZTE5REEwci9EcDdOZHhlUFdzejJVMklEYnFPa3NvSDIyai9HRzJP?= =?gb2312?B?ZUVJR3BiMGRKeFk4K2JNMVZ5MWR4WEZ2RTg0Yncvc2ZPa1orMmorZmxRS2Ju?= =?gb2312?B?dkNaTGJIYkZhQndSWUFSYzA0TFFoc1lIWWZON1lOUTROazl6ZndURDdVTUlm?= =?gb2312?B?MkhrUG1ZMi81MkhpZUtqT2lCc3VUaEtZVHdzNE1CQ1h1Y1Q3QTdlLy9OU3Zq?= =?gb2312?B?eDBJWCtBRnJoYUtLUlM1T2VDVVBqNGQyKzdGQ2dWTVJFMEJLb1p0eVBqR1Rj?= =?gb2312?B?NU9jeEs0bGxsWndrZ2JGSmVKbUVjV0lIZ1FSMGk1VFJSN2k5M24zUWRaa1My?= =?gb2312?B?OEZxYldPYVR1bnBwZnkrWmtwRXhXdUpBM0JQdnFaY09WTUtOSFRBNWoycUNi?= =?gb2312?B?dnVtVUJZLzhMcG5VQ3ByZVgwYm9XSytIYm15K1g1aVhmaWVEQ2RaR0V0U3ZH?= =?gb2312?B?OE1QNjNqaFFXMkVQTmNlTiszSGhBcnJtd2dBWUJCbmtpc1JZUGc1QTdLOWp4?= =?gb2312?B?R1RzVDVqSmJ5dWkzMmM4OWJLVVIzRVJvU21JM0t6TXE4RkI0Zzh5ZkVtaHdu?= =?gb2312?B?ZnJ1a2lpZVc5UGxKZlhYb0VYTDhOTmgzSkZjNWViSEtaYnEyaEpYakUyZVlt?= =?gb2312?B?WFZYa2J1MFRxdllYUjU4TGlLaXcyK0hhVmRscFZaUVdxWW9sVTBCc2FxNVFu?= =?gb2312?B?QjNiVlhxcTlnUHRVZ1lSeEdUZDJJbnlGK2VEb1N0eWkweVpHdmZEQmtSYkZs?= =?gb2312?B?VlNtcXF3SlhHdElEV2tIRmZ1a2pTblN6SDNJRUNydGtJK2tFaUtTRTlqWGlQ?= =?gb2312?B?QUptUmVRNWpCUmlZc2lKblE0bS9QT05kVjBoQUxuSHJIRSsxVitUbE5NMHMv?= =?gb2312?B?cHR1bGtZR2xuWWwwdVF4dXg5SFVwcmRnM3Y2OTlOR0NQWG1pNFRqeTkzaTRa?= =?gb2312?B?MVF2VWk1S1NrOENLc0hORzJUd3Aramh3WTRCbGFqWjRoTnU0cFlVYkxSNkhK?= =?gb2312?B?eUM1N0U3RUtiZ1VwUmJXK3F6aTB2aVFucjFBV29nU2duL04rUXF4WlI3QmZD?= =?gb2312?B?WTNNeW5ySVJUNGdxeUFXRjZCeVppTGhyTUJIR2JSQjd5UXpuQ015bXNXSW92?= =?gb2312?B?amJqd1ZnaXdISjF0bng1d3V2OVhQNFVWaVFHaWllOFk3NGZpeHdZblNZeUZR?= =?gb2312?B?ZmpJdXBOM1ZVZ2RmaHNTeUJ5clhDSDBBUExSbGhvRTI4dTRHd3d6bThiaTVE?= =?gb2312?B?NThYeHhKZHpOaDNURDZGSkN2V2Z2Vnl4YVhZNXhRTHZZc1V4ZnU5UUdYc2JU?= =?gb2312?B?K25iK3d1b2N4VXl1TDBuWUQwTk1XajUxVGF2VnR0TzAvY080Vm5JelNnPT0=?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?gb2312?B?V0l1UlBQV3ZyS0QwUlAzVmxhOVZxdEVqZE9sWEhibWZpMXNoRk1aMmMxcUMx?= =?gb2312?B?UDVQSjhHM1VIZUpUZjJYNjN2ckxuck4vY2c0aC9USWFnU3ZMaUZ0K2V3SGVt?= =?gb2312?B?bTNPQVhWdWlYUURUMFM5ekptZlluditqR3lVRk9lWHIrUkI0K3Vtd1p1UGli?= =?gb2312?B?TWFkeHRLdUI4RnI3VnVnT1NsVVcyNFhnTlRQZXNDak0wMUE1em5wSUdaYU1r?= =?gb2312?B?cy9uZXV1bFBRa0dqb0VYajYzbjloT3ljODI4ZW9pbHhrNUxrSXF1ZzBqbEpu?= =?gb2312?B?ZE9rUDFNUXFldm5jYVZqbUkySGU2YUw5QVdxL2orTGJEWGxIdVEyMkYxK1Bs?= =?gb2312?B?anczMUpQV1JhZnA2dDF2L25pVVVHU2dabEF1QUxCM0pDTnBzWVJnOVF3a1l6?= =?gb2312?B?U21zSXZ0YmxDeDJJN3V6UFh4VlErRWVsVXNuMkQ5ZnYreTBjVWhXZmRDSjZp?= =?gb2312?B?bW1ON3NReEtCd2tjem9IWDZUczlKbkFJNytvNjdPdnhLOUtPNll3WmhzY2V4?= =?gb2312?B?UjI4aCtLQTZHdkNvK0RIb1YzN3VWcExFS3pIL1hMS3lvaXZzczJ3OGtxbi9q?= =?gb2312?B?RDQySTlsN1V4eFF2bTBsUTRuektzU1REWXZhcHRyWW4ycFRUWFhCZ294cE9W?= =?gb2312?B?WHVzUXRVWEd4MWJqSTNNYis0enpHREZ2NzFMZkkvL29LL0IxYkI2L21ZRGRC?= =?gb2312?B?enNUM0VnbE1BMEZ0cWUvdXFPajg4UnZ6TXhUemExbitma04xVEdYazhoZjQw?= =?gb2312?B?M1lObXRlank3NkZYTTlHTi9NbVF3OUFNZlNNd05HMm1Kak9lVEVwT0xhUnFF?= =?gb2312?B?dDhCR21leTJnTjFYY3Z0SHB0c3lWV3VmY2xZNXc4L04xV0V0UEhGWTBleUQv?= =?gb2312?B?cHNBTjI1OHNuL0lBbkZxRUxPUXNKc01QeG9zRml1ZTh6VG9aY0p4YU9BbWhV?= =?gb2312?B?eEs0Ni8wOUtxTEl2emxXSVI5QVpsL3lWbFlseU9kLzg2NSt4TWdzNXFwSnRN?= =?gb2312?B?VXhDV0ZQZmhHNzhpZ3ZicWJtc1RLMG1QNWFiRmNnRDRzUUcvelNiWXpCeWJB?= =?gb2312?B?d2UyckN6Z1JtdksrUXR2VFkrS1hkRlJ6N3YxUDZ5c0hyMEFDZktUWXVab1Zv?= =?gb2312?B?ZTZkUWlLTEI4WTRPMEREaXRxS0UyUllNa1lqNFBiOTZzT0JmeWV3MzNLMWZS?= =?gb2312?B?OWRRTmpjNGw4TzJqZEN5USt1YXBMTW81UFdsSmZIUkY2Nk43K0lndVROVXVi?= =?gb2312?B?WFdhcmRoSnNqeFduaGlKY2JoYllzNGkyUXJOWW5rYkRHSTIzVHVPNklCVmRH?= =?gb2312?B?Q1NSQlVhSTZYTFJJSmV3djVlUDFoVE1SbHN1TloxWmRzU0lRWE1mb2lRK0xT?= =?gb2312?B?cjRaMDdaRTloWk1KYTY5ZHBpSG1nRXllT0dNQTAvZ3hCNlN6TlF2MDdSeDlK?= =?gb2312?B?ZWtONEUvQWo1N0h1VFRSUGdGYVhuMmpNSlhvUGFlelltRjVYQVJNcE5XUDBi?= =?gb2312?B?YXRqbzB2K1VGdTVZL1dReTZsbzI1eDY0eFJzdDVKanFUOE4rL3NyclJ6bVpu?= =?gb2312?B?QXJCVStaSzcrajk4cXgvQ1NPeUZWa3hDVmJseG1lSHp6RWJGbkhNU0dXMFNL?= =?gb2312?B?Z3dqSzFLcm5wOWpxUHcxck91Nmh1M3c9PQ==?= Content-Type: multipart/alternative; boundary="_000_OSBPR01MB29978241F67EB78F0390C6809B802OSBPR01MB2997jpnp_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-15995.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OSBPR01MB2997.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 407f9aab-6e1d-4620-6099-08dd86e70041 X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Apr 2025 06:28:05.5964 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCPR01MB6802 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_OSBPR01MB29978241F67EB78F0390C6809B802OSBPR01MB2997jpnp_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 SGkgYWxsLA0KVGhhbmtzIGZvciBleHBsYWluaW5nLiAgSSBoYXZlIGdvdCBpdC4NCg0KX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX18NCreivP7IyzogQnJ1Y2UgTW9tamlhbiA8YnJ1Y2VA bW9tamlhbi51cz4NCreiy83KsbzkOiAyMDI1xOo01MIyOcjVIDExOjA5DQrK1bz+yMs6IEggV2l0 dCA8aTVkQGxpdmUuY29tPg0Ks63LzTogcGdzcWwtbm92aWNlQGxpc3RzLnBvc3RncmVzcWwub3Jn IDxwZ3NxbC1ub3ZpY2VAbGlzdHMucG9zdGdyZXNxbC5vcmc+DQrW98ziOiBSZTogd2h5IGF0IHRp bWUgem9uZSB0el9vZmZzZXQgbm90IGVxdWFsIHR6X25hbWU/IHR6X25hbWUgaGFzIHNhbWUgb2Zm c2V0IGluIHBnX3RpbWV6b25lX25hbWVzDQoNCk9uIFR1ZSwgQXByIDI5LCAyMDI1IGF0IDAyOjQw OjQ1QU0gKzAwMDAsIEggV2l0dCB3cm90ZToNCj4gc2VsZWN0DQo+ICcyMDI1LTAyLTAzIDE1OjA0 OjA1Jzo6dGltZXN0YW1wdHogYXQgdGltZSB6b25lICcrMDg6MDAnLA0KPiAnMjAyNS0wMi0wMyAx NTowNDowNSc6OnRpbWVzdGFtcHR6IGF0IHRpbWUgem9uZSAnQXNpYS9TaGFuZ2hhaScNCj4NCj4g ZGlzcGxheQ0KPiB8MjAyNS0wMi0wMiAyMzowNDowNS4wMDB8MjAyNS0wMi0wMyAxNTowNDowNS4w MDB8DQoNClRoZSBzaWduIGlzIHdyb25nIGluIHRoZSBmaXJzdCBjb2x1bW46DQoNCiAgICAgICAg U0VMRUNUDQogICAgICAgICcyMDI1LTAyLTAzIDE1OjA0OjA1Jzo6dGltZXN0YW1wdHogYXQgdGlt ZSB6b25lICctMDg6MDAnLA0KICAgICAgICAnMjAyNS0wMi0wMyAxNTowNDowNSc6OnRpbWVzdGFt cHR6IGF0IHRpbWUgem9uZSAnQXNpYS9TaGFuZ2hhaScNCiAgICAgICAgOw0KICAgICAgICAgICAg ICB0aW1lem9uZSAgICAgICB8ICAgICAgdGltZXpvbmUNCiAgICAgICAgLS0tLS0tLS0tLS0tLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICAgICAgICAgMjAyNS0wMi0wNCAwNDowNDow NSB8IDIwMjUtMDItMDQgMDQ6MDQ6MDUNCg0KU2VlOg0KDQogICAgICAgIGh0dHBzOi8vd3d3LnBv c3RncmVzcWwub3JnL2RvY3MvY3VycmVudC9kYXRldGltZS1wb3NpeC10aW1lem9uZS1zcGVjcy5o dG1sDQoNCiAgICAgICAgVGhlIG9mZnNldCBmaWVsZHMgc3BlY2lmeSB0aGUgaG91cnMsIGFuZCBv cHRpb25hbGx5IG1pbnV0ZXMgYW5kDQogICAgICAgIHNlY29uZHMsIGRpZmZlcmVuY2UgZnJvbSBV VEMuIFRoZXkgaGF2ZSB0aGUgZm9ybWF0IGhoWzptbVs6c3NdXQ0KICAgICAgICBvcHRpb25hbGx5 IHdpdGggYSBsZWFkaW5nIHNpZ24gKCsgb3IgLSkuIFRoZSBwb3NpdGl2ZSBzaWduIGlzIHVzZWQN CiAgICAgICAgZm9yIHpvbmVzIHdlc3Qgb2YgR3JlZW53aWNoLiAoTm90ZSB0aGF0IHRoaXMgaXMg dGhlIG9wcG9zaXRlIG9mDQogICAgICAgIHRoZSBJU08tODYwMSBzaWduIGNvbnZlbnRpb24gdXNl ZCBlbHNld2hlcmUgaW4gUG9zdGdyZVNRTC4pIGhoDQogICAgICAgIGNhbiBoYXZlIG9uZSBvciB0 d28gZGlnaXRzOyBtbSBhbmQgc3MgKGlmIHVzZWQpIG11c3QgaGF2ZSB0d28uDQoNCi0tDQogIEJy dWNlIE1vbWppYW4gIDxicnVjZUBtb21qaWFuLnVzPiAgICAgICAgaHR0cHM6Ly9tb21qaWFuLnVz DQogIEVEQiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgaHR0cHM6Ly9lbnRl cnByaXNlZGIuY29tDQoNCiAgRG8gbm90IGxldCB1cmdlbnQgbWF0dGVycyBjcm93ZCBvdXQgdGlt ZSBmb3IgaW52ZXN0bWVudCBpbiB0aGUgZnV0dXJlLg0K --_000_OSBPR01MB29978241F67EB78F0390C6809B802OSBPR01MB2997jpnp_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable
Hi all,
Thanks for explaining.  I have got it.

=B7=A2=BC=FE=C8=CB: Bruce Momjian <bruce@momjian.us>
=B7=A2=CB=CD=CA=B1=BC=E4: 2025=C4=EA4=D4=C229=C8=D5 11:09
=CA=D5=BC=FE=C8=CB: H Witt <i5d@live.com>
=B3=AD=CB=CD: pgsql-novice@lists.postgresql.org <pgsql-novic= e@lists.postgresql.org>
=D6=F7=CC=E2: Re: why at time zone tz_offset not equal tz_name?= tz_name has same offset in pg_timezone_names
 
On Tue, Apr 29, 2025 at 02:40:45AM +0000, H= Witt wrote:
> select
> '2025-02-03 15:04:05'::timestamptz at time zone '+08:00',
> '2025-02-03 15:04:05'::timestamptz at time zone 'Asia/Shanghai'
>
> display
> |2025-02-02 23:04:05.000|2025-02-03 15:04:05.000|

The sign is wrong in the first column:

        SELECT
        '2025-02-03 15:04:05'::timestamp= tz at time zone '-08:00',
        '2025-02-03 15:04:05'::timestamp= tz at time zone 'Asia/Shanghai'
        ;
            &nb= sp; timezone       |    &= nbsp; timezone
        ---------------------+----------= -----------
         2025-02-04 04:04:05 | 2025= -02-04 04:04:05

See:

        https://www.postgresql.org/docs/current/datetime-posix-timezone-specs.html<= /a>

        The offset fields specify the ho= urs, and optionally minutes and
        seconds, difference from UTC. Th= ey have the format hh[:mm[:ss]]
        optionally with a leading sign (= + or -). The positive sign is used
        for zones west of Greenwich. (No= te that this is the opposite of
        the ISO-8601 sign convention use= d elsewhere in PostgreSQL.) hh
        can have one or two digits; mm a= nd ss (if used) must have two.

--
  Bruce Momjian  <bruce@momjian.us>    =     https://momjian.us
  EDB           = ;            &n= bsp;            = ;  https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the futur= e.
--_000_OSBPR01MB29978241F67EB78F0390C6809B802OSBPR01MB2997jpnp_--