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 1uZuoI-00A88h-5C for pgsql-general@arkaria.postgresql.org; Thu, 10 Jul 2025 17:11:50 +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 1uZuoF-00F6zC-ST for pgsql-general@arkaria.postgresql.org; Thu, 10 Jul 2025 17:11:48 +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 1uZuoF-00F6z3-Et for pgsql-general@lists.postgresql.org; Thu, 10 Jul 2025 17:11:48 +0000 Received: from mail-oi1-x22c.google.com ([2607:f8b0:4864:20::22c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uZuoD-006sMa-2j for pgsql-general@postgresql.org; Thu, 10 Jul 2025 17:11:47 +0000 Received: by mail-oi1-x22c.google.com with SMTP id 5614622812f47-40af40aeef6so417663b6e.3 for ; Thu, 10 Jul 2025 10:11:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752167504; x=1752772304; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=nBkByMdS7QEl9TD8UGD+2vtBRunN3dBJNzCrjJcuU9E=; b=F6Uz5M4+4OrfjZKbReaZUHVDRCvzukksOYpnXPjNANJbW8JJkK4Q6XS+qJhoNg3PpW hsfgwisz0eyCjuW85ryfdYySpB8uVIR8UcRODSB01nk69i0Gis+0q38Tl4D3faM/1mLb NAHROGIqPeKwnXWeuLf1Jg/HldvzSrXsUfCQpsHyF/rGq/rGvQLX98q4cC0/BHSIhNaE EkootSjkvF0K0BJsYAX4ORFo8nu7tf1egkFUt3CoRgKUm7Nfm2APRC1n6BeJ+opXAxbW DrTbf7SmebT+iIbYc64Y0hPLYOjRfmdAJEFIxwMW5LqUt1EwiSG2TXSz/nxzT5TLbtm8 RhrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752167504; x=1752772304; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=nBkByMdS7QEl9TD8UGD+2vtBRunN3dBJNzCrjJcuU9E=; b=e1F0CSCyRapEsnhYAK6yXstlwzMVrHyKaMii5TeouWJAzHlWgZTXY3Thmz7jE6bM/x 7we81PY4yk21GvEPtueJ/17/M5lqN+TOi19XjLLGSQyoW7wnl8brPFrsJUfRmHgRlSyo ufZ8+x9OwJgRHcGS7VRte1LrLIabZUZ3xzLsG63df7B0nKkYKQK61Z8Xujb0qzhvn+ol TjwUC/Xivur6zKZPvASgJ9Nn3Dr1aB9z/7a1I5tie8pXWFrEOkCEnc5l4gUV7kxA5Pp4 fXOAMg7C+d09Nt+SQWSnxsr8WYmJwF8eLUgsYUpFoLLZSnHYYeqccfqvz2Jb18EuS4wh 4xxg== X-Gm-Message-State: AOJu0YzUohdGf96xEFUxJzZXFelQS8IipbG5T9VVlRdaktKINP0Xt8TK Du7jgyLPQNJr+B5NK06eCUzfIpsPHxXJx/ZInLJXLzg6A3lnAn8t5sipGyhoe3ldTbS7SeAtgUg AtZAbsxSv1fLvCKj2TG/iC1YmIY82X6de4A== X-Gm-Gg: ASbGnct9vcscynRvGJsrjHARfhYU/yrJk6wvPQWAXjp8J6bllYGV2f2ImDoEZgYy82p PyPM66fGmA1ueGOoQhCBBkcPsP/rrlifn3/3x0AN/wgLrar+sAjW998Md4Uir9AcMGbteHW8C4Z dq1J33h1F9/PuWCNQqQUoT5wd0DK3zBCcanE4IzNErpy/FYucPrIhAzk2irGuxsGA7p/mpi0r0v U5x X-Google-Smtp-Source: AGHT+IGZPwnYmWd19P3nh9e0IbTHbPt1Prgt/rDUIepPf3IUA0pYoLaJwCAO3YykFqPq0VTwdQfesn91q3EeQ74RLzg= X-Received: by 2002:a05:6808:4f2b:b0:408:fe75:41b1 with SMTP id 5614622812f47-41511cf53bemr208388b6e.29.1752167503719; Thu, 10 Jul 2025 10:11:43 -0700 (PDT) MIME-Version: 1.0 References: <7f90e1f3-7e0b-4b87-8cb6-f2862755fd3c@aklaver.com> In-Reply-To: <7f90e1f3-7e0b-4b87-8cb6-f2862755fd3c@aklaver.com> From: Ron Johnson Date: Thu, 10 Jul 2025 13:11:32 -0400 X-Gm-Features: Ac12FXwW2EbbrnTydkgiT9bUxc6HrrfBRDcF2P49YfjmzEPmTsT-iyvzIo8yXrw Message-ID: Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...) To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000a57e050639964992" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a57e050639964992 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Jul 10, 2025 at 12:26=E2=80=AFPM Adrian Klaver wrote: > 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. > What even is an aggregate hash function? (I can imagine a few possibilities, but don't want to assume.) --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000a57e050639964992 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Jul 10, 2025 at 12:26=E2=80=AFPM = Adrian Klaver <adrian.klave= r@aklaver.com> wrote:
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.

What even is an aggregate hash function?=C2= =A0 (I can imagine a few possibilities, but don't want to assume.)

--
=
Death to <Re= dacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
--000000000000a57e050639964992--