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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: jani(dot)rahkola(at)iki(dot)fi, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Documentation of return values of range functions lower and upper
Date: 2020-11-11 17:19:38
Message-ID: 53ec9f116bea9252d7fa9341e024530553656c42.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Wed, 2020-11-11 at 09:25 +0000, 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 values infinity and
> -infinity, this is not correct, as those values are returned if explicitly
> used as either bound.

+1

Perhaps it would be better to say

NULL if the range is empty or has no lower/upper bound

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2020-11-11 19:32:13 Re: Addition to content
Previous Message Chris Wilson 2020-11-11 11:29:09 Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?