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

On 7/11/25 09:03, Florents Tselai wrote:

> 
> That's an ideal use case for an extension indeed .
> 
> @Dominique I'd suggest searching for these function on GitHub, just in 
> case there are already implementations out there.
> I've seen a lot of weird aggregates out there for niche cases.
> 
> If not, it might be an interesting weekend project for me to explore.

The SQLite extension that incorporates these functions is here:

https://sqlite.org/src/file?name=ext/misc/shathree.c&ci=tip


-- 
Adrian Klaver
adrian.klaver@aklaver.com