w3resource

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



Follow us on Facebook and Twitter for latest update.