Re: Documentation of return values of range functions lower and upper

2023-11-13 Thread Laurenz Albe
On Mon, 2023-11-13 at 16:08 -0500, Bruce Momjian wrote: > Backpatched to PG 16. Thanks! Yours, Laurenz Albe

Re: Documentation of return values of range functions lower and upper

2023-11-13 Thread Bruce Momjian
On Thu, Nov 2, 2023 at 06:22:59PM -0400, Bruce Momjian wrote: > On Thu, Nov 2, 2023 at 03:42:53PM +0100, Laurenz Albe wrote: > > On Thu, 2023-11-02 at 10:14 -0400, Bruce Momjian wrote: > > > Better, though "Is the range's upper bound unbounded?" makes me cringe. > > > > > > Oh, yeah, totally

Re: Documentation of return values of range functions lower and upper

2023-11-02 Thread Bruce Momjian
On Thu, Nov 2, 2023 at 03:42:53PM +0100, Laurenz Albe wrote: > On Thu, 2023-11-02 at 10:14 -0400, Bruce Momjian wrote: > > Better, though "Is the range's upper bound unbounded?" makes me cringe. > > > > Oh, yeah, totally cringe, me too.  :-) > > > > > It is not the bound that is bounded or not,

Re: Documentation of return values of range functions lower and upper

2023-11-02 Thread Laurenz Albe
On Thu, 2023-11-02 at 10:14 -0400, Bruce Momjian wrote: > Better, though "Is the range's upper bound unbounded?" makes me cringe. > > Oh, yeah, totally cringe, me too.  :-) > > > It is not the bound that is bounded or not, but the range. > > > > How about "Is the range unbounded at the upper

Re: Documentation of return values of range functions lower and upper

2023-11-02 Thread Bruce Momjian
On Thu, Nov 2, 2023 at 08:56:13AM +0100, Laurenz Albe wrote: > On Wed, 2023-11-01 at 18:03 -0400, Bruce Momjian wrote: > > On Wed, Nov 1, 2023 at 09:40:43PM +0100, Laurenz Albe wrote: > > > > Yes, I agree this documentation needs help. > > > > > > > > For upper/lower(), it is clear that the

Re: Documentation of return values of range functions lower and upper

2023-11-02 Thread Laurenz Albe
On Wed, 2023-11-01 at 18:03 -0400, Bruce Momjian wrote: > On Wed, Nov 1, 2023 at 09:40:43PM +0100, Laurenz Albe wrote: > > > Yes, I agree this documentation needs help. > > > > > > For upper/lower(), it is clear that the documentation is better saying > > > "unspecified" rather than infinite.

Re: Documentation of return values of range functions lower and upper

2023-11-01 Thread Bruce Momjian
On Wed, Nov 1, 2023 at 09:40:43PM +0100, Laurenz Albe wrote: > > Yes, I agree this documentation needs help. > > > > For upper/lower(), it is clear that the documentation is better saying > > "unspecified" rather than infinite. The fact that upper/lower_inf() > > returns false for +/-Infinity

Re: Documentation of return values of range functions lower and upper

2023-11-01 Thread Laurenz Albe
On Wed, 2023-11-01 at 16:28 -0400, Bruce Momjian wrote: > On Wed, Nov 18, 2020 at 05:28:44PM +0100, Laurenz Albe wrote: > > On Wed, 2020-11-18 at 22:49 +0900, Fujii Masao wrote: > > > On 2020/11/12 17:14, Laurenz Albe wrote: > > > > On Wed, 2020-11-11 at 18:19 +0100, Laurenz Albe wrote: > > > > >

Re: Documentation of return values of range functions lower and upper

2023-11-01 Thread Bruce Momjian
On Wed, Nov 18, 2020 at 05:28:44PM +0100, Laurenz Albe wrote: > On Wed, 2020-11-18 at 22:49 +0900, Fujii Masao wrote: > > On 2020/11/12 17:14, Laurenz Albe wrote: > > > > > On Wed, 2020-11-11 at 18:19 +0100, Laurenz Albe wrote: > > > > > Table 9.54 in page > > > > >

Re: Documentation of return values of range functions lower and upper

2020-11-18 Thread Laurenz Albe
On Wed, 2020-11-18 at 22:49 +0900, Fujii Masao wrote: > On 2020/11/12 17:14, Laurenz Albe wrote: > > > On Wed, 2020-11-11 at 18:19 +0100, Laurenz Albe wrote: > > > > Table 9.54 in page > > > > https://www.postgresql.org/docs/current/functions-range.html states > > > > that the > > > > functions

Re: Documentation of return values of range functions lower and upper

2020-11-18 Thread Fujii Masao
On 2020/11/12 17:14, Laurenz Albe wrote: On Wed, 2020-11-11 at 18:19 +0100, Laurenz Albe wrote: Table 9.54 in page https://www.postgresql.org/docs/current/functions-range.html states that the functions lower and upper return NULL if the requested bound is infinite. If the element type of the

Re: Documentation of return values of range functions lower and upper

2020-11-12 Thread Laurenz Albe
On Wed, 2020-11-11 at 18:19 +0100, Laurenz Albe wrote: > > Table 9.54 in page > > https://www.postgresql.org/docs/current/functions-range.html states that the > > functions lower and upper return NULL if the requested bound is infinite. If > > the element type of the range contains the special

Re: Documentation of return values of range functions lower and upper

2020-11-11 Thread Laurenz Albe
On Wed, 2020-11-11 at 09:25 +, PG Doc comments form wrote: > Table 9.54 in page > https://www.postgresql.org/docs/current/functions-range.html states that the > functions lower and upper return NULL if the requested bound is infinite. If > the element type of the range contains the special