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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eugen Konkov <kes-kes(at)yandex(dot)ru>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Why 'infinity' is not in range '[2019-01-02, infinity]'?
Date: 2019-04-29 21:30:55
Message-ID: 7991.1556573455@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Eugen Konkov <kes-kes(at)yandex(dot)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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2019-04-29 23:13:05 Re: COALESCE doccumentation
Previous Message Eugen Konkov 2019-04-29 18:22:16 Re: Why 'infinity' is not in range '[2019-01-02, infinity]'?