Re: Why 'infinity' is not in range '[2019-01-02, infinity]'? - Mailing list pgsql-docs

From Tom Lane
Subject Re: Why 'infinity' is not in range '[2019-01-02, infinity]'?
Date
Msg-id 7991.1556573455@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why 'infinity' is not in range '[2019-01-02, infinity]'?  (Eugen Konkov <kes-kes@yandex.ru>)
Responses Re: Why 'infinity' is not in range '[2019-01-02, infinity]'?  (Eugen Konkov <kes-kes@yandex.ru>)
List pgsql-docs
Eugen Konkov <kes-kes@yandex.ru> writes:
> if   you  allow I will suggest to map/convert 'infinity' value to
> unbound range, for datatypes which defines 'infinity' value.

That was intentionally rejected in the original range types design,
and even if we thought that decision was wrong, it's too late to
change it now.

There's probably some merit in having the documentation avoid the
use of "infinity" when it really means "unbounded", but I'm not
sure we can avoid it altogether without being obscure.

            regards, tom lane



pgsql-docs by date:

Previous
From: Eugen Konkov
Date:
Subject: Re: Why 'infinity' is not in range '[2019-01-02, infinity]'?
Next
From: Bruce Momjian
Date:
Subject: Re: COALESCE doccumentation