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 1lKL0V-00080C-3h for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Mar 2021 13:05:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lKL0U-0005pa-2N for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Mar 2021 13:05: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 1lKKqK-0003FN-GU for pgsql-bugs@lists.postgresql.org; Thu, 11 Mar 2021 12:55:09 +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 1lKKqH-0000I2-QF for pgsql-bugs@lists.postgresql.org; Thu, 11 Mar 2021 12:55: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=h6ciSzvlsEXXVj15+HFB1wVS/5YLXU7Ncja+6thl7R0=; b=sIDlph9Tghc/KveOc5Qk6vJm1N rln17DOkKVuCenQDpW0FyNidL9ILvywVgYcFEwQHWvI5T+4NNjr9VfIyyb887Dhw0AHcB86MZM4XV A885ons4t7MItdLg2fNnx8W/2mlYw64FA15o6HGZnA5BE70P6J2JuRTbM/iLivdAUfdZclcX49d3N S9YqpRtFAz7xmA/7cg/eY9uaKOuvf7AlwXwc2dTf68Nu4gMMmQVYmXJmECKqRegSCvtT2rwVwiH35 sCTiEGoRqsYN3IINkfM8enFQ2Vrlwdkh7wgvhoWuEh4AZnQtTrsAeNBJzvoKrQ8pbQkZLNbCIM/Yk 4LfgH1wg==; 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 1lKKqF-00082F-Rc for pgsql-bugs@lists.postgresql.org; Thu, 11 Mar 2021 12:55:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lKKqE-0001nm-Il for pgsql-bugs@lists.postgresql.org; Thu, 11 Mar 2021 12:55:02 +0000 Content-Type: multipart/mixed; boundary="===============5975973158629977846==" MIME-Version: 1.0 Subject: BUG #16923: Timestamptz always returns utc time when resultformat is in binary format. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mjfshark@gmail.com Reply-To: mjfshark@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 11 Mar 2021 12:54:11 +0000 Message-ID: <16923-02bede34869fc819@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 --===============5975973158629977846== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjkyMwpMb2dnZWQgYnk6ICAgICAgICAgIE1hcmsgRm9yZApFbWFpbCBh ZGRyZXNzOiAgICAgIG1qZnNoYXJrQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEyLjMK T3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwCkRlc2NyaXB0aW9uOiAgICAgICAgCgpUZXN0 ZWQgc2VydmVyIHZlcnNpb24gMTIuMywgY2xpZW50IHZlcnNpb25zIDEwLjEzICgzMmJpdCBhbmQg NjRiaXQpIGFuZAoxMy4yLig2NGJpdCkNCklzc3VlOg0KVXNpbmcgbGlicHEuZGxsIGFuZCByZXF1 ZXN0aW5nIGEgcmVzdWx0IHNldCBpbiBiaW5hcnkgZm9ybWF0LiAgVGltZXN0YW1wdHoKcmVzdWx0 cyBhcmUgcmV0dXJuZWQgaW4gVVRDIHRpbWV6b25lIGluc3RlYWQgb2YgdGhlIGN1cnJlbnQgc2Vz c2lvbidzCnRpbWV6b25lIHNldHRpbmcuICBOb3RlIHRoYXQgaW4gdGV4dCBmb3JtYXQgdGhlIHRp bWVzdGFtcHR6IGlzIHJldHVybmVkCnByb3Blcmx5IGNvbnZlcnRlZC4gIEFsc28gbm90ZSB0aGF0 IFRpbWV0eiByZXN1bHRzIGFyZSBjb252ZXJ0ZWQgY29ycmVjdGx5CnJlZ2FyZGxlc3Mgb2YgdGhl IHJlc3VsdCBzZXQgZm9ybWF0IChiaW5hcnkgb3IgdGV4dC4pDQoNCkV4cGVjdGVkIHJlc3VsdHM6 DQpUaGUgZG9jdW1lbnRhdGlvbiBzZWVtcyB0byBzdGF0ZSB0aGF0IFRpbWVzdGFtcHR6IGZpZWxk cyB3aWxsIGJlIHJldHVybmVkCmNvbnZlcnRlZCB0byB0aGUgY3VycmVudGx5IHNldCB0aW1lem9u ZSBzZXNzaW9uIHByb3BlcnR5IGFuZCBkb2Vzbid0IG1lbnRpb24KdGhlIGFib3ZlIGJlaGF2aW9y LiAgVGhpcyBjb21iaW5lZCB3aXRoIHRpbWV0eiBmaWVsZHMgYmVpbmcgY29udmVydGVkCnJlZ2Fy ZGxlc3Mgb2Ygb3V0cHV0IGZvcm1hdCBzZWVtcyBpbmNvbnNpc3RlbnQuDQoNClRoYW5rIHlvdS4K Cg== --===============5975973158629977846==--