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 1mdV9U-0001LX-GF for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Oct 2021 10:18:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mdV9S-0005RD-Vf for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Oct 2021 10:18:22 +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 1mdUhB-0006ww-3C for pgsql-bugs@lists.postgresql.org; Thu, 21 Oct 2021 09:49:09 +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 1mdUh8-0004v4-6v for pgsql-bugs@lists.postgresql.org; Thu, 21 Oct 2021 09:49:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=q3Td3d+dwaojX7Vk79T0w+ryGQXI7WOcwzomFOPLwAg=; b=FHIHSQCIYOHDXSJLrtwNyJ6z1a vd077xpIPklIImUlvM4CENV7Nr5L6Y7AY8jxorn/afPR2NdLiQYbQLqVv75qSSUsGSW8nBz/Aj6DZ sahR1frCt+HPFd5O7k4w5KpqonT4l/TyMVjXN0f9+wTqS//mW2SwLdv9y3u7yZ9FaMawrnlU4vHZc bDjzFhoiumxmBSldN1JlKtJ1V1kbxhsrC6D/0ZZfQnGKF/l/NgCIuYHjSRuEXBQa0ZBW1ZYoofmyY 1vYY3kj9wH5Cm6l3Ha3UHMj0oZUSzMwmryia8XsdXPHtqityGB39DEO7xxcbVxte+BzTzACo6l6MX SoLLLBdg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mdUh6-0005FO-RY for pgsql-bugs@lists.postgresql.org; Thu, 21 Oct 2021 09:49:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mdUh4-0000lZ-Gr for pgsql-bugs@lists.postgresql.org; Thu, 21 Oct 2021 09:49:02 +0000 Content-Type: multipart/mixed; boundary="===============2569025886459574970==" MIME-Version: 1.0 Subject: BUG #17240: at time zone ... ; wrong result To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: marek.lall@eesti.ee Reply-To: marek.lall@eesti.ee, pgsql-bugs@lists.postgresql.org Date: Thu, 21 Oct 2021 09:48:39 +0000 Message-ID: <17240-cdccc24b9eee2d2c@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2569025886459574970== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzI0MApMb2dnZWQgYnk6ICAgICAgICAgIE1hcmVrIEzDpGxsCkVtYWls IGFkZHJlc3M6ICAgICAgbWFyZWsubGFsbEBlZXN0aS5lZQpQb3N0Z3JlU1FMIHZlcnNpb246IDEz LjQKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4KRGVzY3JpcHRpb246ICAgICAgICAKCkhlbGxv IQ0KDQojIFNFTEVDVCB2ZXJzaW9uKCk7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIHZlcnNpb24gICAgICAgICAgICAgCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFBvc3RncmVTUUwgMTMu NCAoRGViaWFuIDEzLjQtMS5wZ2RnMTAwKzEpIG9uIGFhcmNoNjQtdW5rbm93bi1saW51eC1nbnUs CmNvbXBpbGVkIGJ5IGdjYyAoRGViaWFuIDguMy4wLTYpIDguMy4wLCA2NC1iaXQNCigxIHJvdykN Cg0KDQojIFNFVCBUaW1lWm9uZT0nVVRDJzsNCg0KIyBzZWxlY3QgKiBmcm9tIHBnX3RpbWV6b25l X25hbWVzIHdoZXJlIG5hbWUgbGlrZSAnQW1lcmljYS9Mb3NfQW5nZWxlcyc7DQogICAgICAgIG5h bWUgICAgICAgICB8IGFiYnJldiB8IHV0Y19vZmZzZXQgfCBpc19kc3QgDQotLS0tLS0tLS0tLS0t LS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tDQogQW1lcmljYS9Mb3NfQW5n ZWxlcyB8IFBEVCAgICB8IC0wNzowMDowMCAgfCB0DQooMSByb3cpDQoNCiMgc2VsZWN0IG5vdygp DQogLCBub3coKSBhdCB0aW1lIHpvbmUgJ0FtZXJpY2EvTG9zX0FuZ2VsZXMnIGFzIGNvcnJlY3QN CiAsIG5vdygpIGF0IHRpbWUgem9uZSAnLTA3OjAwOjAwJyBhcyB3cm9uZzsNCg0KICAgICAgICAg ICAgICBub3cgICAgICAgICAgICAgIHwgICAgICAgICAgY29ycmVjdCAgICAgICAgICAgfCAgICAg ICAgICAKd3JvbmcgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t DQogMjAyMS0xMC0yMSAwOToyOTowNy41OTE5NjIrMDAgfCAyMDIxLTEwLTIxIDAyOjI5OjA3LjU5 MTk2MiB8IDIwMjEtMTAtMjEKMTY6Mjk6MDcuNTkxOTYyDQooMSByb3cpDQoNCi0tPiBDT0xVTU4g IldST05HIiBJUyBFWFBFQ1RFRCBUTyBIQVZFIFRIRSBTQU1FIFZBTFVFIEFTIENPTFVNTiAiQ09S UkVDVCINCg0KIyBzZWxlY3QgdGltZXN0YW1wdHonMjAyMS0xMC0wMSAwMDowMDowMCBVVEMnIGF0 IHRpbWUgem9uZQonQW1lcmljYS9Mb3NfQW5nZWxlcycgYXMgY29ycmVjdF8xDQogLCB0aW1lc3Rh bXB0eicyMDIxLTEwLTAxIDAwOjAwOjAwIFVUQycgYXQgdGltZSB6b25lICctMDc6MDAnIGFzIHdy b25nXzENCiAsIHRpbWVzdGFtcHR6JzIwMjEtMTAtMDEgMDA6MDA6MDAgQW1lcmljYS9Mb3NfQW5n ZWxlcycgYXQgdGltZSB6b25lCidBbWVyaWNhL0xvc19BbmdlbGVzJyBhcyBjb3JyZWN0XzINCiAs IHRpbWVzdGFtcHR6JzIwMjEtMTAtMDEgMDA6MDA6MDAgLTA3OjAwOjAwJyBhdCB0aW1lIHpvbmUg Jy0wNzowMCcgYXMKd3JvbmdfMg0KICwgdGltZXN0YW1wdHonMjAyMS0xMC0wMSAwMDowMDowMCAt MDc6MDA6MDAnIGF0IHRpbWUgem9uZQonQW1lcmljYS9Mb3NfQW5nZWxlcycgYXMgY29ycmVjdF8z DQogLCB0aW1lc3RhbXB0eicyMDIxLTEwLTAxIDAwOjAwOjAwIEFtZXJpY2EvTG9zX0FuZ2VsZXMn IGF0IHRpbWUgem9uZQonLTA3OjAwJyBhcyB3cm9uZ18zOw0KIA0KICAgICAgY29ycmVjdF8xICAg ICAgfCAgICAgICB3cm9uZ18xICAgICAgIHwgICAgICBjb3JyZWN0XzIgICAgICB8ICAgICAgCndy b25nXzIgICAgICAgfCAgICAgIGNvcnJlY3RfMyAgICAgIHwgICAgICAgd3JvbmdfMyAgICAgICAN Ci0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tLS0tLS0tDQogMjAyMS0wOS0zMCAxNzowMDowMCB8IDIwMjEtMTAtMDEgMDc6 MDA6MDAgfCAyMDIxLTEwLTAxIDAwOjAwOjAwIHwKMjAyMS0xMC0wMSAxNDowMDowMCB8IDIwMjEt MTAtMDEgMDA6MDA6MDAgfCAyMDIxLTEwLTAxIDE0OjAwOjAwDQooMSByb3cpDQoNCi0tPiBDT0xV TU5TICJXUk9OR188Tj4iIEFSRSBFWFBFQ1RFRCBUTyBIQVZFIFRIRSBTQU1FIFZBTFVFIEFTIENP TFVNTgoiQ09SUkVDVF88Tj4iCgo= --===============2569025886459574970==--