PostgreSQL lower_inf() Function

The PostgreSQL lower_inf() function checks whether the lower bound of a given range or multirange is infinite.

PostgreSQL lower_inf() Syntax

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

lower_inf(anyrange) -> boolean
lower_inf(anymultirange) -> boolean

Parameters

anyrange

Required. A range value.

anymultirange

Required. A multirange value.

Return value

The PostgreSQL lower_inf() function checks whether the lower bound of a given range or multirange is infinite.

PostgreSQL lower_inf() Examples

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

Example 1

SELECT
  lower_inf('(1, 5)'::int4range),
  lower_inf('(, 5)'::int4range);

 lower_inf | lower_inf
-----------+-----------
 f         | t

Example 2

SELECT lower_inf('{(, 2], (2, 4)}'::int4multirange);

 lower_inf
-----------
 t