Re: Integer datetimes

Tom Lane napsal(a):
> Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)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