Re: infinity as a date

Tom Lane wrote:
>
> I think that this is an outright bug: if type DATE doesn't have a
> concept of infinity then it should throw an error, not translate
> infinity to NULL.  NULL means "unknown", not "I cannot cope with this
> value".

I agree, which is why I brought it up.

As an aside, why is there a concept of an infinite timestamp but not one
for date? I am puzzled as to why the there is no concept of an infinite
date.

Thanks!

Jc