maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_addarray(integer[], integer[])
Parameters
Name
Type
Mode
a
ARRAY
IN
b
ARRAY
IN
Definition
/* function for adding the elements of nxn size arrays into an nxn size array */ /* Version 20141024_1 */ with q as(select row_number() over(),x from unnest(a) d(x)), q1 as (select row_number() over(),x from unnest(b) d(x)) select array_agg(round((q1.x + q.x)::numeric,2)::int) a from q1 JOIN q ON q.row_number = q1.row_number;