Re: Why is time with timezone 12 bytes?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why is time with timezone 12 bytes?
Date: 2010-09-22 22:51:40
Message-ID: 3597.1285195900@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2010-09-22 22:56:55 Re: Another Modest Proposal: Platforms
Previous Message Josh Berkus 2010-09-22 22:31:27 Re: Configuring synchronous replication