| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Florents Tselai <florents(dot)tselai(at)gmail(dot)com> |
| Cc: | Dominique Devienne <ddevienne(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Aggregate versions of hashing functions (md5, sha1, etc...) |
| Date: | 2025-07-11 16:15:28 |
| Message-ID: | e43a4810-b93b-4b1b-88c0-45231456c60e@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7/11/25 09:03, Florents Tselai wrote:
>
> 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.
The SQLite extension that incorporates these functions is here:
https://sqlite.org/src/file?name=ext/misc/shathree.c&ci=tip
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dominique Devienne | 2025-07-11 16:16:59 | Re: Aggregate versions of hashing functions (md5, sha1, etc...) |
| Previous Message | Florents Tselai | 2025-07-11 16:03:31 | Re: Aggregate versions of hashing functions (md5, sha1, etc...) |