Re: Why is time with timezone 12 bytes?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why is time with timezone 12 bytes?
Дата
Msg-id 3597.1285195900@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why is time with timezone 12 bytes?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Why is time with timezone 12 bytes?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: WIP: Triggers on VIEWs
Следующее
От: David Fetter
Дата:
Сообщение: Re: Another Modest Proposal: Platforms