Other Functions

I l @ ve RuBoard

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] 

I l @ ve RuBoard