ARRAY LOWER Function

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

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

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

Output :

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