Feedback-ID: i76984098:Fastmail
Message-ID: <f5a5bef6-56ca-49cb-b30c-a517ece77255@aklaver.com>
Date: Fri, 11 Jul 2025 08:27:10 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)
To: Dominique Devienne <ddevienne@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAFCRh-8FOZiycyfX4uPB8MTHQTxqNVuW0pdKBuFNQneEZy1PwQ@mail.gmail.com>
 <7f90e1f3-7e0b-4b87-8cb6-f2862755fd3c@aklaver.com>
 <CAFCRh-9SWkL2Evdc8vWrDREGiuDeo58fVqqT4XgpnaKPj7FumQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAFCRh-9SWkL2Evdc8vWrDREGiuDeo58fVqqT4XgpnaKPj7FumQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/f5a5bef6-56ca-49cb-b30c-a517ece77255%40aklaver.com>
Precedence: bulk

On 7/11/25 01:49, Dominique Devienne wrote:
> On Thu, Jul 10, 2025 at 6:25 PM Adrian Klaver <adrian.klaver@aklaver.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.

> 
> So again, I've really surprised this hasn't come up before. --DD

No one else had the need?

Or they came up with workarounds.

-- 
Adrian Klaver
adrian.klaver@aklaver.com