SCALAR_OPERATION - elementwise scalar operation (entire matrix operation)

This procedure implements elementwise scalar operations.

Usage

The SCALAR_OPERATION stored procedure has the following syntax:

SCALAR_OPERATION(matrixIn,matrixOut,operator,value)

Parameters

matrixIn: The name of the input matrix.; Type: NVARCHAR(ANY)
matrixOut: The name of the output matrix.; Type: NVARCHAR(ANY)
operator: The operator to use. Must be one of the following: + - * % ^ & |; Type: NVARCHAR(ANY)
value: The value.; Type: DOUBLE

Returns

BOOLEAN TRUE, if successful.

Examples

CALL nzm..shape('1,2,3,4,5,0,6,7,8',3,3,'A');
CALL nzm..scalar_operation('A','B','*',2.2);
CALL nzm..print('A');
CALL nzm..print('B');
CALL nzm..delete_matrix('A');
CALL nzm..delete_matrix('B');

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

 SCALAR_OPERATION
------------------
 t
(1 row)

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

                           PRINT
-----------------------------------------------------------
 -- matrix: B --
 2.2, 4.4, 6.6
 8.8, 11, 0
 13.2, 15.4, 17.6
(1 row)

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

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