arraymath

pig build pkg pg_arraymath;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_arraymath;		# install via package name, for the active PG version
pig install arraymath;		# install by extension name, for the current active PG version

pig install arraymath -v 18;   # install for PG 18
pig install arraymath -v 17;   # install for PG 17
pig install arraymath -v 16;   # install for PG 16
pig install arraymath -v 15;   # install for PG 15
pig install arraymath -v 14;   # install for PG 14

CREATE EXTENSION arraymath;

CREATE EXTENSION arraymath;

-- Array vs scalar
SELECT ARRAY[1,2,3,4] @< 4;             -- {t,t,t,f}
SELECT ARRAY[3.4,5.6,7.6] @* 8.1;       -- {27.54,45.36,61.56}

-- Array vs array (cycling shorter array)
SELECT ARRAY[1,2,3,4,5,6] @* ARRAY[1,2]; -- {1,4,3,8,5,12}
SELECT ARRAY[1,2,3] @= ARRAY[3,2,1];     -- {f,t,f}

-- Utility functions
SELECT array_sort(ARRAY[9,1,8,2,7]);     -- {1,2,7,8,9}
SELECT array_sum(ARRAY[1,2,3,4,5]);      -- 15
SELECT array_median(ARRAY[1,2,3,4,5]);   -- 3