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 1kyyXJ-0000oz-Fw for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Jan 2021 14:51:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kyyXH-0002Qq-Qg for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Jan 2021 14:51:11 +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 1kyyXH-0002Qh-Je for pgsql-hackers@lists.postgresql.org; Mon, 11 Jan 2021 14:51:11 +0000 Received: from wforward2-smtp.messagingengine.com ([64.147.123.31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kyyX6-00019H-N9 for pgsql-hackers@postgresql.org; Mon, 11 Jan 2021 14:51:07 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailforward.west.internal (Postfix) with ESMTP id 618FE258A; Mon, 11 Jan 2021 09:50:57 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Mon, 11 Jan 2021 09:50:57 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=OAmEgoAmBq/LrQLEIoZtxFadhkxRTqK3bfi5h2usP f4=; b=KfNQNyZAM2o+F36fQzEqMflcI5cTimD3L1L20z/M/dhJLODOwW9N3Hx4C b/XLxHcDkVNjnfDy61YSAdR3xvDm30CNCbPeg1JIO0F6fJoiCZ9s4dP8pQ+pOtmH ZDmymipNQoTxL2FPRbuWmwG2VTuUUgz0+pbiJdSUPXEcVX7En/Xmew4muteCJsc4 7mC3jC4WztMJbYnO+Fy9C5g4tkvoCJOQK5Xj42zHR+YvzrJZwuT6K+Fom9ND6qTy eiyupn44GFrUQdeDuP1t4Y2R2RkuTO4vhTIAjUuRxLr3JGfJlqwXWS2D4L6QOKlW rqHqBmbqWmpwEh607o4KzTKJG0NBw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrvdehuddgjedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeehnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvghnth gvrhhprhhishgvuggsrdgtohhmqeenucggtffrrghtthgvrhhnpeffvdeufedtgffgveff vdehjeekjeekhedvvdeuheeghfffledvgffffffffeejudenucfkphepkeejrddujeejrd ejvddrudegvdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhr ohhmpehpvghtvghrrdgvihhsvghnthhrrghuthesvghnthgvrhhprhhishgvuggsrdgtoh hm X-ME-Proxy: Received: from april.pezone.net (p57b1488e.dip0.t-ipconnect.de [87.177.72.142]) by mail.messagingengine.com (Postfix) with ESMTPA id A4E48240057; Mon, 11 Jan 2021 09:50:55 -0500 (EST) Subject: Re: popcount To: David Fetter , Daniel Verite References: <20201230105535.GJ13234@fetter.org> <5ea2932e-50f5-4a74-9550-5e3291b6652b@manitou-mail.org> <20201230164108.GK13234@fetter.org> Cc: PostgreSQL Development , Vik Fearing From: Peter Eisentraut Organization: EnterpriseDB Message-ID: Date: Mon, 11 Jan 2021 15:50:54 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20201230164108.GK13234@fetter.org> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-12-30 17:41, David Fetter wrote: >> The input may have more than 2 billion bits set to 1. The biggest possible >> result should be 8 billion for bytea (1 GB with all bits set to 1). >> So shouldn't this function return an int8? > It does now, and thanks for looking at this. The documentation still reflects the previous int4 return type (in two different spellings, too).