Re: daterange() is ignoring 3rd boundaries argument

On Mon, Nov 28, 2022 at 5:16 PM Robert KOFLER <rk(at)marksim(dot)org> wrote:

> select daterange('2022-11-01'::date, '2023-01-31'::date, '()')
> returns
> [2022-11-02,2023-01-31) which is deafult of [)
> instead of
> (2022-11-02,2023-01-31)
>

You need to look at the boundary symbol AND the actual lower bound date.

Then read the following about discrete range types for what is happening
here:

https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-DISCRETE

> from manual: 8.17.6. Constructing Ranges and Multiranges
>

Yes, that tells you how to take "text" and turn it into a datum of type
*range. Is discusses input only, not output. Output depends on the
specific type and, as noted above, in particular whether it is discrete or
continuous.

David J.