PostgreSQL lower_inc() Function

The PostgreSQL lower_inc() function checks if the lower bound of a given range or multirange is inclusive.

PostgreSQL lower_inc() Syntax

Here is the syntax of the PostgreSQL lower_inc() function:

lower_inc(anyrange) -> boolean
lower_inc(anymultirange) -> boolean

Parameters

anyrange

Required. A range value.

anymultirange

Required. A multirange value.

Return value

The PostgreSQL lower_inc() function returns a boolean value indicating if the lower bound of the range or multirange is inclusive.

PostgreSQL lower_inc() Examples

Here are some examples of the PostgreSQL lower_inc() function.

Example 1

SELECT lower_inc('[1, 4]'::int4range);

 lower_inc
-----------
 t

Example 2

SELECT lower_inc('(1, 2]'::int4range);

 lower_inc
-----------
 t

Example 3

SELECT lower_inc('(1, 1)'::int4range);

 lower_inc
-----------
 f