w3resource

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

Code:

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

Sample Output:

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

Previous: ARRAY_NDIMS function
Next: ARRAY_FILL functionn



Follow us on Facebook and Twitter for latest update.