ARRAY DIMS Function

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

PostgreSQL ARRAY_DIMS() function

ARRAY_DIMS() function

This function is used to return a text representation of array's dimensions.

Syntax :

array_dims(anyarray)

Return Type :

text

PostgreSQL Version : 9.3

Example : PostgreSQL ARRAY_DIMS() function

SELECT array_dims(ARRAY[[2,2,4], [5,3,6]]);

Output :

 array_dims
------------
 [1:2][1:3]
(1 row)