aggs_for_vecs | Postgres C extension with aggregate functions

aggs_for_vecs is a C library. aggs_for_vecs has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

This is a C-based Postgres extension offering various aggregate functions like min, max, avg, and var_samp that operate on arrays instead of scalars. It treats each array as a "vector" and handles each element independently. So suppose you have 3 rows each with a 4-element array like so:. | id | vals | | -: | :--------- | | 1 | {1,2,3,4} | | 2 | {5,0,-5,0} | | 3 | {3,6,0,9} |. Then SELECT vec_to_min(vals) will pick the minimum item in each array position, giving you {1,0,-5,0}. Note that the functions here are true [aggregate functions] If you want something that provides aggregate-like behavior by computing stats from a single array, take a look at my other extension [aggs_for_arrays] You could say that this extension follows a row-based format and the other a column-based.