public inbox for [email protected]  

help / color / mirror / Atom feed

From: Florents Tselai <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Dominique Devienne <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)
Date: Fri, 11 Jul 2025 19:03:31 +0300
Message-ID: <CA+v5N43bO5Xuiu8Bunn+0RJbVepr2Yn4-0f8U6-hNZe0ctt23A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAFCRh-8FOZiycyfX4uPB8MTHQTxqNVuW0pdKBuFNQneEZy1PwQ@mail.gmail.com>
	<[email protected]>
	<CAFCRh-9SWkL2Evdc8vWrDREGiuDeo58fVqqT4XgpnaKPj7FumQ@mail.gmail.com>
	<[email protected]>

On Fri, Jul 11, 2025, 18:27 Adrian Klaver <[email protected]> wrote:

> On 7/11/25 01:49, Dominique Devienne wrote:
> > On Thu, Jul 10, 2025 at 6:25 PM Adrian Klaver <[email protected]>
> 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.
>
> Even if there was interest in writing the code, given that Postgres 18
> is in Beta I don't see this happening for it's release. That means the
> earliest it would arrive would be Fall of 2026. The alternative would be
> to do like Sqlite and create an extension that incorporates the code.
>

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.

>

view thread (3+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)
  In-Reply-To: <CA+v5N43bO5Xuiu8Bunn+0RJbVepr2Yn4-0f8U6-hNZe0ctt23A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox