GET_VALUE

This procedure returns the value of specified matrix element.

Usage

The GET_VALUE stored procedure has the following syntax:

GET_VALUE(mat_name,inrow,incol)

Parameters

mat_name: The name of matrix.; Type: NVARCHAR(ANY)
inrow: The row index of the element.; Type: INT4
incol: The column index of the element.; Type: INT4

Returns

DOUBLE The value of the matrix element.

Details

This procedure is intended for use with small numbers of values. For retrieving large numbers of values, use alternate approaches that process data in bulk.

Examples

CALL nzm..shape('1,2,3,4,5,0,6,7,8', 3, 3, 'A');
CALL nzm..get_value('A', 2, 3);
CALL nzm..delete_matrix('A');

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

 GET_VALUE
-----------
 0
(1 row)

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