SQL · Array and set-returning functions

array_length()

The length of an array dimension. PostgreSQL.

sqlRunnable example sql course

Syntax

array_length(array, dimension)

Example

Open in the lab

-- PostgreSQL
-- SELECT array_length(ARRAY[1,2,3], 1);

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.