MIME-Version: 1.0
References: <CAFCRh-8FOZiycyfX4uPB8MTHQTxqNVuW0pdKBuFNQneEZy1PwQ@mail.gmail.com>
 <7f90e1f3-7e0b-4b87-8cb6-f2862755fd3c@aklaver.com> <CAFCRh-9SWkL2Evdc8vWrDREGiuDeo58fVqqT4XgpnaKPj7FumQ@mail.gmail.com>
 <f5a5bef6-56ca-49cb-b30c-a517ece77255@aklaver.com>
In-Reply-To: <f5a5bef6-56ca-49cb-b30c-a517ece77255@aklaver.com>
From: Florents Tselai <florents.tselai@gmail.com>
Date: Fri, 11 Jul 2025 19:03:31 +0300
Message-ID: <CA+v5N43bO5Xuiu8Bunn+0RJbVepr2Yn4-0f8U6-hNZe0ctt23A@mail.gmail.com>
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Dominique Devienne <ddevienne@gmail.com>, pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000099bb2d0639a97bd8"
Archived-At: <https://www.postgresql.org/message-id/CA%2Bv5N43bO5Xuiu8Bunn%2B0RJbVepr2Yn4-0f8U6-hNZe0ctt23A%40mail.gmail.com>
Precedence: bulk

--00000000000099bb2d0639a97bd8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Jul 11, 2025, 18:27 Adrian Klaver <adrian.klaver@aklaver.com> wrote=
:

> On 7/11/25 01:49, Dominique Devienne wrote:
> > On Thu, Jul 10, 2025 at 6:25=E2=80=AFPM Adrian Klaver <adrian.klaver@ak=
laver.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.
>
> 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.

>

--00000000000099bb2d0639a97bd8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 11, 2025, 18:27 Adri=
an Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@ak=
laver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 7/11/=
25 01:49, Dominique Devienne wrote:<br>
&gt; On Thu, Jul 10, 2025 at 6:25=E2=80=AFPM Adrian Klaver &lt;<a href=3D"m=
ailto:adrian.klaver@aklaver.com" target=3D"_blank" rel=3D"noreferrer">adria=
n.klaver@aklaver.com</a>&gt; wrote:<br>
&gt;&gt; On 7/10/25 04:48, Dominique Devienne wrote:<br>
&gt;&gt;&gt; Seems so logical to me, that these hashing functions were avai=
lable<br>
&gt;&gt;&gt; are aggregates, I can&#39;t be the first one to think of that,=
 can it?<br>
&gt;&gt;<br>
&gt;&gt; I&#39;ve been on this list since late 2002 and I don&#39;t recall =
this ever<br>
&gt;&gt; being brought up. Now it is entirely possible that age has dimmed =
my<br>
&gt;&gt; recall abilities:) Though a quick search seems to confirm my memor=
y.<br>
&gt; <br>
&gt; Hi. Given that [SQLite&#39;s SHA3 hasher][1] has it (OK, for [8 months=
 only][2]),<br>
&gt; it&#39;s hardly an original idea. And when considering that `sha3_quer=
y`<br>
&gt; (and `sha1_query` before it) have been there for years, and provide<br=
>
&gt; equivalent functionality, again, this is not novel by any stretch of<b=
r>
&gt; the imagination.<br>
<br>
Even if there was interest in writing the code, given that Postgres 18 <br>
is in Beta I don&#39;t see this happening for it&#39;s release. That means =
the <br>
earliest it would arrive would be Fall of 2026. The alternative would be <b=
r>
to do like Sqlite and create an extension that incorporates the code.<br></=
blockquote></div></div><div dir=3D"auto"><br></div><div dir=3D"auto">That&#=
39;s an ideal use case for an extension indeed .</div><div dir=3D"auto"><br=
></div><div dir=3D"auto">@Dominique I&#39;d suggest searching for these fun=
ction on GitHub, just in case there are already implementations out there.=
=C2=A0</div><div dir=3D"auto">I&#39;ve seen a lot of weird aggregates out t=
here for niche cases.</div><div dir=3D"auto"><br></div><div dir=3D"auto">If=
 not, it might be an interesting weekend project for me to explore.</div><d=
iv dir=3D"auto"><div class=3D"gmail_quote gmail_quote_container"><blockquot=
e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol=
id;padding-left:1ex">
</blockquote></div></div></div>

--00000000000099bb2d0639a97bd8--