Re: Integer datetimes - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Integer datetimes
Date
Msg-id FF2AF55C-4F32-472A-848E-E999C6DB1187@decibel.org
Whole thread Raw
In response to Re: Integer datetimes  (Neil Conway <neilc@samurai.com>)
Responses Re: Integer datetimes
List pgsql-hackers
On May 5, 2007, at 10:38 AM, Neil Conway wrote:
> On Sat, 2007-05-05 at 11:03 -0400, Tom Lane wrote:
>> I'm not necessarily opposed to changing the default configure  
>> selection,
>> but I am opposed to removing the FP code entirely.
>
> I would be satisfied with changing the default to integer and
> deprecating the FP code (but keeping it around as a configure option).
> Are there any objections to doing this for 8.3?

One question... I've always assumed that FP date times suffers from  
the inexact math issues that floats do; is that true?

The only use I can think of for huge date values would be astronomy.  
I know they deal with huge numbers, so maybe huge times as well. If  
there is that kind of demand perhaps we'd want to continue supporting  
FP dates... maybe via contrib, or as a different base data type.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: plperl vs. bytea
Next
From: Bruce Momjian
Date:
Subject: Re: Integer datetimes