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.
