PostgreSQL Range Functions

This page organizes the functions that PostgreSQL provides for range types.

  1. isempty()

    The PostgreSQL isempty() function checks if a given range or multirange value is empty.

  2. lower_inc()

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

  3. lower_inf()

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

  4. lower()

    The PostgreSQL lower(range) function returns the lower bound of a given range or multirange.

  5. multirange()

    The PostgreSQL multirange() function returns a multirange containing just the given range.

  6. range_merge()

    The PostgreSQL range_merge() function computes the smallest range that includes all specified ranges or the entire multirange.

  7. unnest()

    The PostgreSQL unnest(anymultirange) function expands a multirange into a set of range values.

  8. upper_inc()

    The PostgreSQL upper_inc() function checks whether the upper bound of a given range is inclusive.

  9. upper_inf()

    The PostgreSQL upper_inf() function checks whether the upper bound of a given range is infinite.

  10. upper()

    The PostgreSQL upper(range) function returns the upper bound of a given range or multirange.