Function Category: Range Functions

multirangesel() — PostgreSQL range function

multirangesel(): restriction selectivity for multirange operators. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

nummultirange() — PostgreSQL range function

nummultirange(): nummultirange constructor. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

numrange() — PostgreSQL range function

numrange(): numrange constructor. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

numrange_subdiff() — PostgreSQL range function

numrange_subdiff(): float8 difference of two numeric values. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

range_gist_consistent() — PostgreSQL range function

range_gist_consistent(): GiST support. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

range_gist_penalty() — PostgreSQL range function

range_gist_penalty(): GiST support. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

range_gist_picksplit() — PostgreSQL range function

range_gist_picksplit(): GiST support. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

range_gist_same() — PostgreSQL range function

range_gist_same(): GiST support. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

range_gist_union() — PostgreSQL range function

range_gist_union(): GiST support. PostgreSQL range functions — signature, volatility, version applicability and an illustrative example.

range_merge() — PostgreSQL range function

range_merge(): the smallest range which includes both of the given ranges. PostgreSQL range functions — signature, volatility, version applicability and…