Re: Why overlaps is not working - Mailing list pgsql-general

> 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.

through expermentation I came up with:

logs=# select '5874897-12-31'::date;
     date
---------------
 5874897-12-31
(1 row)

logs=# select '5874898-12-31'::date;
ERROR:  date out of range: "5874898-12-31"

Regards,

Richard Broersma Jr
l