GT - elementwise greater than

This procedure implements an element wise computation of the C := A > B comparison, where A, B, and C are matrices.

Usage

The GT stored procedure has the following syntax:

GT(matrixAname,matrixBname,matrixCname)

Parameters

matrixAname: The name of input matrix A.; Type: NVARCHAR(ANY)
matrixBname: The name of input matrix B.; Type: NVARCHAR(ANY)
matrixCname: The name of output matrix C.; Type: NVARCHAR(ANY)

Returns

BOOLEAN TRUE, if successful.

Details

Matrices A and B must have the same number of dimensions, that is the same number of rows and columns. The output matrix C is given the same shape. Matrix C must not exist prior to the operation. C is a matrix containing only zeros and ones, corresponding to FALSE and TRUE at respective positions.

Examples

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

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

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

 GT
----
 t
(1 row)

                 PRINT
-----------------------------------------
 -- matrix: C --
 0, 0, 0
 0, 1, 0
 1, 0, 1
(1 row)

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

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

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