Re: Integer datetimes - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: Integer datetimes
Date
Msg-id 47E81AF1.5030701@sun.com
Whole thread Raw
In response to Re: Integer datetimes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Integer datetimes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane napsal(a):
> Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
>> The result will be two datatypes datetime and timestamp_int or timestamp_float.
> 
> This is not happening, at least not without 100 times more work than
> anyone has shown willingness to put into the issue.  It seems fairly
> clear that everyone thinks the int64 datatypes will be the mainstream
> usage, and the float implementation will be interesting only on very
> old platforms or for very specialized applications.  I cannot see us
> putting in the effort needed to refactor the code as two
> simultaneously-available datatypes.

I understand your arguments, but it is important for in-place upgrade. If you 
will start new postgreSQL on e.g 8.3 database cluster, you need method how to 
process floating point timestamp. Minimal we need to have cast from floating 
point timestamp to integer timestamp. I put it on my ToDo with low priority.
    Zdenek


pgsql-hackers by date:

Previous
From: Kurt Roeckx
Date:
Subject: Re: gcc 4.3 breaks ContribCheck in 8.2 and older.
Next
From: Magnus Hagander
Date:
Subject: Re: Problem with site doc search