CREATE EXTENSION arraymath; SELECT ARRAY[1,2,3,4] @< 4; ?column? ----------- {t,t,t,f} (1 row) SELECT ARRAY[3.4,5.6,7.6] @* 8.1; ?column? --------------------- {27.54,45.36,61.56} (1 row) SELECT ARRAY[1,2] @+ ARRAY[3,4]; ?column? ---------- {4,6} (1 row) SELECT ARRAY[1,2,3,4,5,6] @* ARRAY[1,2]; ?column? ---------------- {1,4,3,8,5,12} (1 row) SELECT ARRAY[1,1,1,1] @< ARRAY[0,2]; ?column? ----------- {f,t,f,t} (1 row) SELECT ARRAY[1,2,3] @= ARRAY[3,2,1]; ?column? ---------- {f,t,f} (1 row) WITH a AS ( SELECT array_agg(a) AS b FROM generate_series(1,100) a ) SELECT b @+ b FROM a; ?column? -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46,48,50,52,54,56,58,60,62,64,66,68,70,72,74,76,78,80,82,84,86,88,90,92,94,96,98,100,102,104,106,108,110,112,114,116,118,120,122,124,126,128,130,132,134,136,138,140,142,144,146,148,150,152,154,156,158,160,162,164,166,168,170,172,174,176,178,180,182,184,186,188,190,192,194,196,198,200} (1 row) WITH a AS ( SELECT array_agg(a) AS b FROM generate_series(1,100) a ) SELECT b @+ ARRAY[0,1] FROM a; ?column? ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {1,3,3,5,5,7,7,9,9,11,11,13,13,15,15,17,17,19,19,21,21,23,23,25,25,27,27,29,29,31,31,33,33,35,35,37,37,39,39,41,41,43,43,45,45,47,47,49,49,51,51,53,53,55,55,57,57,59,59,61,61,63,63,65,65,67,67,69,69,71,71,73,73,75,75,77,77,79,79,81,81,83,83,85,85,87,87,89,89,91,91,93,93,95,95,97,97,99,99,101} (1 row) SELECT ARRAY[1,1,1,1] @< ARRAY[1,NULL,1,1]; ?column? -------------- {f,NULL,f,f} (1 row) SELECT ARRAY[NULL] @< ARRAY[NULL]; ?column? ---------- {NULL} (1 row) SELECT ARRAY[[1,2,3],[1,2]] @+ 1; ERROR: multidimensional arrays must have array expressions with matching dimensions SELECT ARRAY[]::integer[] @< ARRAY[NULL]::integer[]; ERROR: only 1-dimensional arrays supported CONTEXT: SQL function "array_lt_array" statement 1