Downloads
Home   >   mailing lists

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-_3oKeCDKOFWQ=bxBPNZWtrvL1ucG5wjOxh2HgEbz-qtw@mail.gmail.com
Whole thread Raw
In response to Re: Aggregate versions of hashing functions (md5, sha1, etc...)  (Florents Tselai <florents.tselai@gmail.com>)
Responses Re: Aggregate versions of hashing functions (md5, sha1, etc...)
List pgsql-general
Tree view 
On Fri, Jul 11, 2025 at 6:05 PM Florents Tselai
<florents.tselai@gmail.com> wrote:
> On Fri, Jul 11, 2025, 18:27 Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>> [...] 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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)
Next
From: Edmundo Robles
Date:
Subject: I have a suspicious query