Home > mailing lists

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

From	jian he
Subject	range with infinity bound data type disallow extra empty white space.
Date	July 9, 2022 09:13:26
Msg-id	CACJufxHLeBsr3=Yv-Ev53yUE=xgV0XNSechM96hqja49HGVp1A@mail.gmail.com Whole thread Raw
Responses	Re: range with infinity bound data type disallow extra empty white space. ("David G. Johnston" <david.g.johnston@gmail.com>)
List	pgsql-general

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

From: Josef Šimánek
Date: 09 July 2022, 03:50:30
Subject: Re: Database designs

From: "David G. Johnston"
Date: 09 July 2022, 10:06:09
Subject: Re: range with infinity bound data type disallow extra empty white space.