-- Syntax
MARRAY var IN mintervalExp [, var IN mintervalExp]
VALUES cellExp

-- Creating an array of domain [ 1:100, -50:200 ] with values 1
SELECT MARRAY x IN [ 1:100, -50:200 ] VALUES 1c

-- Creating an array of 256 X 101 with the value in each cell equal to the number of the row
SELECT MARRAY x IN [ 0:255, 0:100 ] VALUES x[0]

-- Creating a histogram of values ranging 0 to 9 in the mr array
SELECT MARRAY v IN [ 0 : 9 ]
       VALUES CONDENSE +
              OVER  x IN sdom(mr)
              WHERE mr[x] = v[0]
              USING 1
FROM mr