A PostgreSQL datarange type with inclusive upper bound
The daterange type, as well as other range types, is by default output with non-exclusive upper range. This extension defines a type which is the same but with inclusive upper range. Such behaviour is more convenient in some practical use cases.
See example:
CREATE EXTENSION daterange_inclusive;
SELECT daterange('[2024年01月01日,2024年06月01日]');
daterange
-------------------------
[2024年01月01日,2024年06月02日)
SELECT daterange_inclusive('[2024年01月01日,2024年06月01日]');
daterange_inclusive
-------------------------
[2024年01月01日,2024年06月01日]
USE_PGXS=1 PG_CONFIG=/path_to_pgconfig make install