Re: infinity as a date - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Re: infinity as a date
Date
Msg-id 3DF82ADF.1030801@mega-bucks.co.jp
Whole thread Raw
In response to infinity as a date  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Responses Re: infinity as a date  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recovery Mode
Next
From: Tom Lane
Date:
Subject: Re: infinity as a date