Re: How to enter daterange into a raw? - SOLVED - Mailing list pgadmin-support

From David Johnston
Subject Re: How to enter daterange into a raw? - SOLVED
Date
Msg-id 1375366293851-5765884.post@n5.nabble.com
Whole thread Raw
In response to Re: How to enter daterange into a raw? - SOLVED  (Csanyi Pal <csanyipal@gmail.com>)
List pgadmin-support
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.



pgadmin-support by date:

Previous
From: Jan-Peter Seifert
Date:
Subject: Re: PgAdmin V 1.16.1 Error - Comment on database
Next
From: "Hall, Samuel L (Sam)"
Date:
Subject: Error Messages