Re: Why is time with timezone 12 bytes?

Josh Berkus <josh@agliodbs.com> writes:
> Also, what is the real range of our 8-byte *integer* timestamp?
>> 
>> See the fine manual.  I believe the limits have more to do with
>> calendar arithmetic than with the nominal range of 2^64 microseconds.

> I'm asking based on that.  The docs only give the limits for a *float*
> timestamp.  I'd like to fix the docs, but I can only do it if I have the
> data ...

It's the same, because the limits are calendar based (particularly,
the Julian-date functions) and not dependent on the representation.
        regards, tom lane