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

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: How to enter daterange into a raw? - SOLVED
Дата
Msg-id 1375366293851-5765884.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: How to enter daterange into a raw? - SOLVED  (Csanyi Pal <csanyipal@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jan-Peter Seifert
Дата:
Сообщение: Re: PgAdmin V 1.16.1 Error - Comment on database
Следующее
От: "Hall, Samuel L (Sam)"
Дата:
Сообщение: Error Messages