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> <CA+v5N43bO5Xuiu8Bunn+0RJbVepr2Yn4-0f8U6-hNZe0ctt23A@mail.gmail.com>
In-Reply-To: <CA+v5N43bO5Xuiu8Bunn+0RJbVepr2Yn4-0f8U6-hNZe0ctt23A@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Fri, 11 Jul 2025 18:16:59 +0200
Message-ID: <CAFCRh-_3oKeCDKOFWQ=bxBPNZWtrvL1ucG5wjOxh2HgEbz-qtw@mail.gmail.com>
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)
To: Florents Tselai <florents.tselai@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	pgsql-general <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-_3oKeCDKOFWQ%3DbxBPNZWtrvL1ucG5wjOxh2HgEbz-qtw%40mail.gmail.com>
Precedence: bulk

On Fri, Jul 11, 2025 at 6:05=E2=80=AFPM Florents Tselai
<florents.tselai@gmail.com> wrote:
> On Fri, Jul 11, 2025, 18:27 Adrian Klaver <adrian.klaver@aklaver.com> wro=
te:
>> [...] create an extension that incorporates the code.
>
> That's an ideal use case for an extension indeed .

Extensions are of no use to me, unfortunately, unless built-in and
official. So if I have to wait for v19, so be it. But the ball has to
get rolling at least.

And extensions address only the missing aggregate "overloads". Not the
fact current md5() and pgcrypto.digest() are not TOAST-aware to be
"really streaming", and low-memory.