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 1rkKNm-00BxQG-HA for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Mar 2024 08:54:43 +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 1rkKNk-00FXnm-0M for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Mar 2024 08:54:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rkEoh-008TVf-Ub for pgsql-bugs@lists.postgresql.org; Wed, 13 Mar 2024 02:58:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rkEof-004Do8-KN for pgsql-bugs@lists.postgresql.org; Wed, 13 Mar 2024 02:58:07 +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=Gl/wDvpcac1tO3gEFmPia4vIx7YECA4PSwxJFmTvg+E=; b=53CZDE4pNrwKJ5joiopYoHFGuZ ClWMADK5tbcjqmNN+filPrkE/oUEet+n8z5XJwZtajhW2paqtiJn7xCeTt0lkItSb0Ad1FaAS7aXL d6CS64LwzF/09dPn8RXe46ZHKbmbYbUWzqE656Dxc/9qp9BtdltXj1ElE4u12kFP2jRjDhw1DKIL5 EUg3z7TPaHgSOx3RpSkvlh9Cdc4ZA4/zhFgN8A+Imwq5dK/sgKV2mHaCx6yhBIgqJB7PEdTeRxvy3 DMMXWnNo/V7adXlL8wkeRl0EKDTOdcbJdo3pbNpYh4uOt81T2DNqec6qIDba+8jbeLyVdl3Fex4Wy S4GKZf+g==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rkEod-00B0y9-Mi for pgsql-bugs@lists.postgresql.org; Wed, 13 Mar 2024 02:58:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rkEob-00HGZP-RI for pgsql-bugs@lists.postgresql.org; Wed, 13 Mar 2024 02:58:02 +0000 Content-Type: multipart/mixed; boundary="===============6896602323620044366==" MIME-Version: 1.0 Subject: BUG #18390: exponentiation produces float datatype, but nth-root produces integer To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: robb@helical.com Reply-To: robb@helical.com, pgsql-bugs@lists.postgresql.org Date: Wed, 13 Mar 2024 02:57:57 +0000 Message-ID: <18390-03499fe4f5a0ac71@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 --===============6896602323620044366== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM5MApMb2dnZWQgYnk6ICAgICAgICAgIFJvYmIgQWxsYW4KRW1haWwg YWRkcmVzczogICAgICByb2JiQGhlbGljYWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTUuNQpP cGVyYXRpbmcgc3lzdGVtOiAgIE1hYyBPUyBTb25vbWEgMTQuMy4xICgyM0Q2MCkKRGVzY3JpcHRp b246ICAgICAgICAKCkFuIGV4cG9uZW50aWF0aW9uIGZyb20gYSBmbG9hdCBwcm9kdWNlcyBhIGZs b2F0aW5nIHBvaW50IHJlc3VsdDoNCg0KZnVuZHM9IyBzZWxlY3QgKDEuMV4xMCk7DQogICAgICA/ Y29sdW1uPyAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAyLjU5Mzc0MjQ2MDEwMDAwMDAN CigxIHJvdykNCg0KSG93ZXZlciwgYW4gbnRoLXJvb3QgY2FsY3VsYXRpb24gZnJvbSB0aGF0IGZs b2F0IHJlc3VsdCBkb2VzIE5PVCBwcm9kdWNlIGEKbmV3IGZsb2F0IHJlc3VsdDoNCg0KZnVuZHM9 IyBzZWxlY3QgKDIuNTkzNzQyNDYwMTAwMDAwMF4oMS8xMCkpOw0KICAgICAgP2NvbHVtbj8gICAg ICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tDQogMS4wMDAwMDAwMDAwMDAwMDAwDQooMSByb3cpDQoN Cg0KT25seSB3aGVuIHRoZSByb290IGZhY3RvcnMgYXJlIGZsb2F0cyBkb2VzIHRoZSByZXN1bHQg Y29lcmNlIHRvIGEgZmxvYXQ6DQoNCmZ1bmRzPSMgc2VsZWN0ICgyLjU5Mzc0MjQ2MDEwMDAwMDBe KDEuMC8xMCkpOw0KICAgICAgICA/Y29sdW1uPyAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0NCiAxLjEwMDAwMDAwMDAwMDAwMDAwMDAwDQooMSByb3cpDQoNCmZ1bmRzPSMgc2VsZWN0 ICgyLjU5Mzc0MjQ2MDEwMDAwMDBeKDEvMTAuMCkpOw0KICAgICAgICA/Y29sdW1uPyAgICAgICAg DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAxLjEwMDAwMDAwMDAwMDAwMDAwMDAwDQooMSBy b3cpCgo= --===============6896602323620044366==--