Re: Why overlaps is not working
От | Andrus |
---|---|
Тема | Re: Why overlaps is not working |
Дата | |
Msg-id | 002f01c70667$58dc01c0$4814eb50@acer обсуждение исходный текст |
Ответ на | Re: Why overlaps is not working (Richard Broersma Jr <rabroersma@yahoo.com>) |
Ответы |
Re: Why overlaps is not working
Re: Why overlaps is not working |
Список | pgsql-general |
> apparently date doesn't know anything about infinity. However, from what > I've read in my "SQL for > smarties" book regarding temporial database design, unknown future dates > were stored as: > '9999-12-31' > > Would this help, since any enddate with this value would be be enterpreted > as an enddate that has > not yet occured? when you arrive at the date for records effective period > to close just update > the enddate to the today's date. select date '10000-1-1'< date '99991231' return false. If my database contains dates greater than DATE '9999-12-31' then this check fails. This is why I'm searching for a real MAX_DATE value in Postgres. It would be nice if there will be MAX_DATE constant in Postgres or some one row system table contains MAX_DATE value. Andrus.
В списке pgsql-general по дате отправления: