w3resource
MySQL Tutorial

PostgreSQL ARRAY_LENGTH() function

ARRAY_LENGTH() function

This function is used to return the length of the requested array dimension.

Syntax:

array_length(anyarray, int)

Return Type :

int

PostgreSQL Version: 9.3

Example: PostgreSQL ARRAY_LENGTH() function

Code:


SELECT array_length(array[1,2,3], 1);

Sample Output:

  array_length
--------------
            3
(1 row)

Previous: ARRAY_FILL function
Next: ARRAY_LOWER function



New Content: Composer: Dependency manager for PHP, R Programming