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 1lOdh0-0008NJ-F6 for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Mar 2021 09:51:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lOdgy-0004MM-Eh for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Mar 2021 09:51:16 +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 1lOdgx-0004MD-Nc for pgsql-hackers@lists.postgresql.org; Tue, 23 Mar 2021 09:51:16 +0000 Received: from forward1-smtp.messagingengine.com ([66.111.4.223]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOdgu-0001Ay-Pz for pgsql-hackers@postgresql.org; Tue, 23 Mar 2021 09:51:14 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailforward.nyi.internal (Postfix) with ESMTP id 8D6A01940903; Tue, 23 Mar 2021 05:51:11 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 23 Mar 2021 05:51:11 -0400 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=fm2; bh=zuI50Tvlv1P/vUeAqqkI7+BEGvwvGJPKBH2SnarPl 0I=; b=FlPUhxbi3SUy3XXxSpQCkgqwTgkMI7vhv+oR7j+SbojWOJcaKwIt2KkrB GZWKr4O5BRIWE3GmUjpQqLkAMgUtL3yLgbvMaaCEcweyUkU2AywRXxRDKXniXsfx eusKMyNeeSzb0voMorBtD/Cp1xqliREBNj7UzkkJK5tykOSjTM+1xY6Jvb/oGG/F IIIjEbaoODrctyYMTzGezVWh80OtgD8e9RAM5mBnpvQJqTlE1zaRaJYSvkgwUwD6 WKnmKEBU2t+vhv6wLlSnWxZyIWtyJpYYMbDfF3oGGvDK2cYbSjPrwxmEmE5oxCVY l/SHCvwy++LpZx3nDyzy8OawSb+JQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudegiedgtdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhkffffgggjggtgfesthejredttdefheenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsegvnhhtvg hrphhrihhsvggusgdrtghomheqnecuggftrfgrthhtvghrnhephfefleefueevuddvffeh jedtjeejgfelhfdtvdffheeludetudegfeeftdffffejnecukfhppeeluddrudegrddvfe eirdeiheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehpvghtvghrrdgvihhsvghnthhrrghuthesvghnthgvrhhprhhishgvuggsrdgtohhm X-ME-Proxy: Received: from laptop206oxuk.local (p5b0eec41.dip0.t-ipconnect.de [91.14.236.65]) by mail.messagingengine.com (Postfix) with ESMTPA id 58101240425; Tue, 23 Mar 2021 05:51:10 -0400 (EDT) Subject: Re: popcount To: David Fetter Cc: pgsql-hackers , John Naylor References: <20210111161354.GA8721@fetter.org> <338981.1610984050@sss.pgh.pa.us> <20210119163818.GE8721@fetter.org> <775b91fc-80fa-179d-bb20-0bf230e6db40@enterprisedb.com> <20210321013108.GF7457@fetter.org> From: Peter Eisentraut Message-ID: Date: Tue, 23 Mar 2021 10:51:08 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.16; rv:78.0) Gecko/20100101 Thunderbird/78.8.1 MIME-Version: 1.0 In-Reply-To: <20210321013108.GF7457@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: Archived-At: Precedence: bulk On 21.03.21 02:31, David Fetter wrote: >> I have now read the entire internet on what a suitable name for this >> function could be. I think the emerging winner is BIT_COUNT(), which >> already exists in MySQL, and also in Python (int.bit_count()) and Java >> (Integer.bitCount()). > > Thanks for doing this tedious work. Please find attached the next > version of the patch. committing, with some polishing