Re: Aggregate versions of hashing functions (md5, sha1, etc...) - Mailing list pgsql-general

From Dominique Devienne
Subject Re: Aggregate versions of hashing functions (md5, sha1, etc...)
Date
Msg-id CAFCRh-9SWkL2Evdc8vWrDREGiuDeo58fVqqT4XgpnaKPj7FumQ@mail.gmail.com
Whole thread Raw
In response to Re: Aggregate versions of hashing functions (md5, sha1, etc...)  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Thu, Jul 10, 2025 at 6:25 PM Adrian Klaver <adrian.klaver@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.

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=ext/misc/shathree.c&ci=tip
[2]: https://github.com/sqlite/sqlite/commit/797fcb8433301d995dbe7731765833c82a74a1da



pgsql-general by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin
Next
From: Dominique Devienne
Date:
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)