Re: 2147483642::abstime is null, 2147483644::abstime is null - Mailing list pgsql-general

From Tom Lane
Subject Re: 2147483642::abstime is null, 2147483644::abstime is null
Date
Msg-id 27847.1109951575@sss.pgh.pa.us
Whole thread Raw
In response to Re: 2147483642::abstime is null, 2147483644::abstime is  ("Dr. Stephane Schildknecht" <sschildknecht@linagora.com>)
List pgsql-general
"Dr. Stephane Schildknecht" <sschildknecht@linagora.com> writes:
> Tom Lane wrote:
>> It doesn't.  It returns "invalid" and "infinity".

> Is there a reason for this ?

I suppose the "invalid" value is a legacy thing, but "infinity"
certainly strikes me as useful.  We have that in the regular
timestamp type as well.

If you're asking why those particular encoded values, I dunno.
Certainly it seems like "infinity" needs to be larger than all
normal values so you don't have to special-case it in comparisons.

            regards, tom lane

pgsql-general by date:

Previous
From: "Dr. Stephane Schildknecht"
Date:
Subject: Re: 2147483642::abstime is null, 2147483644::abstime is
Next
From: "Greg Patnude"
Date:
Subject: Re: preserving data after updates