> 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