MIME-Version: 1.0
References: <CAFCRh-8FOZiycyfX4uPB8MTHQTxqNVuW0pdKBuFNQneEZy1PwQ@mail.gmail.com>
 <7f90e1f3-7e0b-4b87-8cb6-f2862755fd3c@aklaver.com>
In-Reply-To: <7f90e1f3-7e0b-4b87-8cb6-f2862755fd3c@aklaver.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Fri, 11 Jul 2025 10:49:20 +0200
Message-ID: <CAFCRh-9SWkL2Evdc8vWrDREGiuDeo58fVqqT4XgpnaKPj7FumQ@mail.gmail.com>
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-9SWkL2Evdc8vWrDREGiuDeo58fVqqT4XgpnaKPj7FumQ%40mail.gmail.com>
Precedence: bulk

On Thu, Jul 10, 2025 at 6:25=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.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.

Hi. Given that [SQLite's SHA3 hasher][1] has it (OK, for [8 months only][2]=
),
it's hardly an original idea. And when considering that `sha3_query`
(and `sha1_query` before it) have been there for years, and provide
equivalent functionality, again, this is not novel by any stretch of
the imagination.

So again, I've really surprised this hasn't come up before. --DD

[1]: https://sqlite.org/src/file?name=3Dext/misc/shathree.c&ci=3Dtip
[2]: https://github.com/sqlite/sqlite/commit/797fcb8433301d995dbe7731765833=
c82a74a1da