public inbox for [email protected]help / color / mirror / Atom feed
Re: Aggregate versions of hashing functions (md5, sha1, etc...) 3+ messages / 3 participants [nested] [flat]
* Re: Aggregate versions of hashing functions (md5, sha1, etc...) @ 2025-07-11 08:49 Dominique Devienne <[email protected]> 2025-07-11 15:27 ` Re: Aggregate versions of hashing functions (md5, sha1, etc...) Adrian Klaver <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Dominique Devienne @ 2025-07-11 08:49 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: [email protected] 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. So again, I've really surprised this hasn't come up before. --DD [1]: https://sqlite.org/src/file?name=ext/misc/shathree.c&ci=tip [2]: https://github.com/sqlite/sqlite/commit/797fcb8433301d995dbe7731765833c82a74a1da ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Aggregate versions of hashing functions (md5, sha1, etc...) 2025-07-11 08:49 Re: Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne <[email protected]> @ 2025-07-11 15:27 ` Adrian Klaver <[email protected]> 2025-07-11 16:03 ` Re: Aggregate versions of hashing functions (md5, sha1, etc...) Florents Tselai <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Adrian Klaver @ 2025-07-11 15:27 UTC (permalink / raw) To: Dominique Devienne <[email protected]>; +Cc: [email protected] 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. > > 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 [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Aggregate versions of hashing functions (md5, sha1, etc...) 2025-07-11 08:49 Re: Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne <[email protected]> 2025-07-11 15:27 ` Re: Aggregate versions of hashing functions (md5, sha1, etc...) Adrian Klaver <[email protected]> @ 2025-07-11 16:03 ` Florents Tselai <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Florents Tselai @ 2025-07-11 16:03 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: Dominique Devienne <[email protected]>; pgsql-general <[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. > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-07-11 16:03 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-07-11 08:49 Re: Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne <[email protected]> 2025-07-11 15:27 ` Adrian Klaver <[email protected]> 2025-07-11 16:03 ` Florents Tselai <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox