INSERT

This procedure inserts one matrix into another.

Usage

The INSERT stored procedure has the following syntax:

INSERT(matrixIn1,matrixIn2,row_start,col_start)

Parameters

matrixIn1: The name of the matrix being inserted into.; Type: NVARCHAR(ANY)
matrixIn2: The name of the matrix being inserted.; Type: NVARCHAR(ANY)
row_start: The row index where insertion should begin.; Type: INT4
col_start: The column index where insertion should begin.; Type: INT4

Returns

BOOLEAN TRUE, if successful.

Details

This procedure work in place, modifying matrixIn1.

Examples

CALL nzm..SHAPE('0', 4, 4, 'A');
CALL nzm..SHAPE('1,2,3,4,5,0,6,7,8', 3, 3, 'B');
CALL nzm..INSERT('A', 'B', 2, 2);
CALL nzm..PRINT('A');
CALL nzm..DELETE_MATRIX('A');
CALL nzm..DELETE_MATRIX('B');

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

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

 INSERT
--------
 t
(1 row)

                           PRINT
-------------------------------------------------------------
 -- matrix: A --
 0, 0, 0, 0
 0, 1, 2, 3
 0, 4, 5, 0
 0, 6, 7, 8
(1 row)

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

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