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. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support