w3resource

PostgreSQL ARRAY_LOWER() function

ARRAY_LOWER() function

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

Syntax:

array_lower(anyarray, int)

Return Type

int

PostgreSQL Version: 9.3

Example: PostgreSQL ARRAY_LOWER() function

Code:

SELECT array_lower('[0:2]={1,2,3}'::int[], 1);

Sample Output: 

 array_lower
-------------
           0
(1 row)

Previous: ARRAY_LENGTH function
Next: ARRAY_PREPEND function