Re: How to enter daterange into a raw? - SOLVED

Csanyi Pal wrote
> Now, I don't understand, why changes pgAdminIII the entered value,
> namely from
> [2013-09-01,2013-11-12]
>
> to
>
> [2013-09-01,2013-11-12)
>
> automatically??
>
> I want to enter [2013-09-01,2013-11-12] because I want to to set this
> range with inclusive bounds.

Are you positive the "after" value is [2013-09-01,2013-11-12) as opposed to
[2013-09-01,2013-11-11). Since "date"s are discrete the later is equivalent
to your input and so the internal representation used to store the data is
the later - commonly deemed the "canonical" or "normalized" form.

Otherwise I have no clue and cannot readily test it myself.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-enter-daterange-into-a-raw-tp5765795p5765884.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.