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 1uZu64-009pEP-Kq for pgsql-general@arkaria.postgresql.org; Thu, 10 Jul 2025 16:26:08 +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 1uZu61-00EjPe-Kv for pgsql-general@arkaria.postgresql.org; Thu, 10 Jul 2025 16:26:06 +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 1uZu60-00EjPW-KO for pgsql-general@lists.postgresql.org; Thu, 10 Jul 2025 16:26:05 +0000 Received: from fhigh-b2-smtp.messagingengine.com ([202.12.124.153]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uZu5x-006s1k-1F for pgsql-general@lists.postgresql.org; Thu, 10 Jul 2025 16:26:04 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfhigh.stl.internal (Postfix) with ESMTP id ABAE37A026B; Thu, 10 Jul 2025 12:25:58 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Thu, 10 Jul 2025 12:25:58 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1752164758; x=1752251158; bh=srkEG37eIF6KdX4vgkdd5glqnl1Ez6XqP6jNaQMl+78=; b= dV55r0DnQQdjyeJOP7bp0xnlnpNbkB5AEtWHjkvtujWnHrt8IOLsaOJhPyYV2Lfp aO/fzGXgLBqTfVjWpDjJ183SSbsH/XaGUxfuosn8xeF2DU/wB1VQzm7tCnw9ftOy EXo0YU+H5nBbPZTW5dGgWAYFpjJl34kQLH+CLYFAtL2c+LwcBoFAXheH+E5cRKak KEYwb8IBvCKMJ+wGjkmM0rRwJlXcPeQC5kKEbmALIcmmVHktK9yhilu7JYkaozw5 MTdY+DRLpVZfFlua+px8Ml6J4hwOhbXX2e77XDGDKShiPGbnrT2CV8fajvxP2CAS 3l3mqarnhjGukipJ0MO1bw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1752164758; x=1752251158; bh=s rkEG37eIF6KdX4vgkdd5glqnl1Ez6XqP6jNaQMl+78=; b=O0B2LZDgiR8cW9ApJ iOKBH40yEcTfz87nOXDjRQ+zjwlO2DrZOBErNqLyvRkLip+7DwPIaSP9Cb31F0nH 1VVJlrr3vAKGcbVeUHtr9a11AzkxX7h75h+q8dJDxoBbzgeBlD4bvcurqIYfhXf5 HToWNLZdIcJcjaS5aRmulEBSEHJMYEJAHOmBazkQVJMhFrhucs3Dsr1KdUQ8cfPT ThCfipmuYu3IiZCCKW/Vv5fozL0UkMxUDfYAlfWLWZPAymbhqocLQGBDNptotKCR l9zxHqD3uxl+lW+Pk85E1Ad1ZgJPwEQLUh+5DrISoISUGpIKzMdDvaYtVCKHnbWG 9ZzYA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdegtdeludcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgrnhcu mfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqne cuggftrfgrthhtvghrnhepiedvhfeiheehgeeuieeljeeitedtjeehudegfeelkedvleek hedtgfeiffefkedunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilh hfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghr tghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepugguvghvihgvnh hnvgesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehl ihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 10 Jul 2025 12:25:57 -0400 (EDT) Message-ID: <7f90e1f3-7e0b-4b87-8cb6-f2862755fd3c@aklaver.com> Date: Thu, 10 Jul 2025 09:25:57 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...) To: Dominique Devienne , pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/10/25 04:48, Dominique Devienne wrote: > Seems so logical to me, that these hashing functions were available > are aggregates, I can't be the first one to think of that, can it? > I've been on this list since late 2002 and I don't recall this ever being brought up. Now it is entirely possible that age has dimmed my recall abilities:) Though a quick search seems to confirm my memory. > Thanks, --DD > -- Adrian Klaver adrian.klaver@aklaver.com