Re: range with infinity bound data type disallow extra empty white space. - Mailing list pgsql-general

From David G. Johnston
Subject Re: range with infinity bound data type disallow extra empty white space.
Date
Msg-id CAKFQuwYc4QmbA+XcNszVXUv83pDgbtnWpxeaweTC=9PfGDL3TQ@mail.gmail.com
Whole thread Raw
In response to range with infinity bound data type disallow extra empty white space.  (jian he <jian.universality@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: jian he
Date:
Subject: range with infinity bound data type disallow extra empty white space.
Next
From: Igor Korot
Date:
Subject: Get the table creation DDL