Other Functions

Some of the included PostgreSQL functions do not fall neatly into a specific category. This section outlines one example of this type of function.

ARRAY_DIMS

Description

The ARRAY_DIMS function returns the number of elements stored in an array field.

Input

ARRAY_DIMS (col)

Example

SELECT ARRAY_DIMS(testscore) FROM students; 

array_dims 
----------
[1:4]