Thread: range with infinity bound data type disallow extra empty white space.

Hi, there.

Not sure this is a bug, or intentional.
select '[10000, )'::int8range; --fail.
select '[10000,)'::int8range; --ok.

tested on pg14.4, pg15.1


--
 I recommend David Deutsch's <<The Beginning of Infinity>>

  Jian


Re: range with infinity bound data type disallow extra empty white space.

From
"David G. Johnston"
Date:
On Friday, July 8, 2022, jian he <jian.universality@gmail.com> wrote:
Hi, there.

Not sure this is a bug, or intentional.
select '[10000, )'::int8range; --fail.
select '[10000,)'::int8range; --ok.

tested on pg14.4, pg15.1


It is documented so I’d say intentional.

“Whitespace is allowed before and after the range value, but any whitespace between the parentheses or brackets is taken as part of the lower or upper bound value.”

David J.