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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: range with infinity bound data type disallow extra empty white space.
Date: 2022-07-09 07:06:09
Message-ID: CAKFQuwYc4QmbA+XcNszVXUv83pDgbtnWpxeaweTC=9PfGDL3TQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday, July 8, 2022, jian he <jian(dot)universality(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2022-07-10 15:40:41 Get the table creation DDL
Previous Message jian he 2022-07-09 06:13:26 range with infinity bound data type disallow extra empty white space.