SHAPE

This procedure creates a matrix filled cyclically with elements from a list.

Usage

The SHAPE stored procedure has the following syntax:
SHAPE(valuelist,rows,cols,matrixCname)
Parameters
valuelist
A comma-separated list of doubles.
Type: NVARCHAR(ANY)
rows
The number of rows.
Type: INT4
cols
The number of columns.
Type: INT4
matrixCname
The name of output matrix C.
Type: NVARCHAR(ANY)
Returns
BOOLEAN TRUE, if successful.

Details

This procedure creates a matrix that is filled cyclically based on the values in the valuelist parameter. For ex-ample, if a matrix of size 3 x 3 is created with a list of "2,3,5,7" the result is 2 3 5 | 7 2 3 | 5 7 2. Note that the well-formedness of the list is not tested.

Examples

call nzm..shape('2,3,5,7',3,3,'A');
call nzm..print('A');
call nzm..delete_matrix('A');

 SHAPE
-------
 t
(1 row)

                 PRINT
-----------------------------------------
 -- matrix: A --
 2, 3, 5
 7, 2, 3
 5, 7, 2
(1 row)

 DELETE_MATRIX
---------------
 t
(1 row)