diff options
| author | Bruce Momjian <bruce@momjian.us> | 2023-11-13 16:08:01 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2023-11-13 16:08:22 -0500 |
| commit | 7539a1b2fc839f45a95f66a42939db13629e79a9 (patch) | |
| tree | ef4a222d29a7f7937188a322c840f08086aa3cec | |
| parent | d1379ebf4c2d3d399e739966dbfa34e92a53b727 (diff) | |
| download | postgresql-7539a1b2fc839f45a95f66a42939db13629e79a9.tar.gz postgresql-7539a1b2fc839f45a95f66a42939db13629e79a9.zip | |
doc: clarify handling of range upper/lower/upper_inf/lower_inf()
Clarify handling of infinite range bounds.
Reported-by: jani.rahkola@iki.fi
Discussion: https://postgr.es/m/160508672127.25505.8356390205508789564@wrigleys.postgresql.org
Co-authored-by: Laurenz Albe
Backpatch-through: 16
| -rw-r--r-- | doc/src/sgml/func.sgml | 20 |
1 files changed, 12 insertions, 8 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 92843b2abb3..202e64d0e07 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -19963,7 +19963,7 @@ SELECT NULLIF(value, '(none)') ... </para> <para> Extracts the lower bound of the range (<literal>NULL</literal> if the - range is empty or the lower bound is infinite). + range is empty or has no lower bound). </para> <para> <literal>lower(numrange(1.1,2.2))</literal> @@ -19981,7 +19981,7 @@ SELECT NULLIF(value, '(none)') ... </para> <para> Extracts the upper bound of the range (<literal>NULL</literal> if the - range is empty or the upper bound is infinite). + range is empty or has no upper bound). </para> <para> <literal>upper(numrange(1.1,2.2))</literal> @@ -20049,7 +20049,8 @@ SELECT NULLIF(value, '(none)') ... <returnvalue>boolean</returnvalue> </para> <para> - Is the range's lower bound infinite? + Does the range have no lower bound? (A lower bound of + <literal>-Infinity</literal> returns false.) </para> <para> <literal>lower_inf('(,)'::daterange)</literal> @@ -20066,7 +20067,8 @@ SELECT NULLIF(value, '(none)') ... <returnvalue>boolean</returnvalue> </para> <para> - Is the range's upper bound infinite? + Does the range have no upper bound? (An upper bound of + <literal>Infinity</literal> returns false.) </para> <para> <literal>upper_inf('(,)'::daterange)</literal> @@ -20121,7 +20123,7 @@ SELECT NULLIF(value, '(none)') ... </para> <para> Extracts the lower bound of the multirange (<literal>NULL</literal> if the - multirange is empty or the lower bound is infinite). + multirange is empty has no lower bound). </para> <para> <literal>lower('{[1.1,2.2)}'::nummultirange)</literal> @@ -20139,7 +20141,7 @@ SELECT NULLIF(value, '(none)') ... </para> <para> Extracts the upper bound of the multirange (<literal>NULL</literal> if the - multirange is empty or the upper bound is infinite). + multirange is empty or has no upper bound). </para> <para> <literal>upper('{[1.1,2.2)}'::nummultirange)</literal> @@ -20207,7 +20209,8 @@ SELECT NULLIF(value, '(none)') ... <returnvalue>boolean</returnvalue> </para> <para> - Is the multirange's lower bound infinite? + Does the multirange have no lower bound? (A lower bound of + <literal>-Infinity</literal> returns false.) </para> <para> <literal>lower_inf('{(,)}'::datemultirange)</literal> @@ -20224,7 +20227,8 @@ SELECT NULLIF(value, '(none)') ... <returnvalue>boolean</returnvalue> </para> <para> - Is the multirange's upper bound infinite? + Does the multirange have no upper bound? (An upper bound of + <literal>Infinity</literal> returns false.) </para> <para> <literal>upper_inf('{(,)}'::datemultirange)</literal> |