Re: empty range

2020-01-20 Thread david . turon
> regression=# select int4range(4,4) = int4range(5,5); > ?column? > -- > t > (1 row) Yes you have right, i don't realize this situation. But what about yust leave empty bit set to True and don't discard the input value - items can be sort and we can see the value - lower(int4range(4,4))

empty range

2020-01-16 Thread david . turon
Hello, default constructor for ranges use lower bound closed '[' and upper bound open ')'. This is correct behavior, but when upper bound is same like lower bound then range is empty. Mathematically is correct again - but in database is lost information about range bounds (lower/upper is NULL).