Re: Using Epoch to save timestamps in 4 bytes?

Поиск
Список
Период
Сортировка
Искать
От
Scott Marlowe
Тема
Re: Using Epoch to save timestamps in 4 bytes?
Дата
в 04:16:19
Msg-id
dcc563d10805090015s10523e0dq5f274635e7419303@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Re: Using Epoch to save timestamps in 4 bytes? Francisco Reyes <lists@stringsutils.com>
Re: Using Epoch to save timestamps in 4 bytes? Tom Lane <tgl@sss.pgh.pa.us>
On Thu, May 8, 2008 at 10:00 PM, Bruce Momjian  wrote:
>
>  Our timestamp has a much larger range than a 4-byte time_t, docs say:
>
>         4713 BC
>         294276 AD

Which is normally great.  Doesn't it have greater precision in the
modern era or something like that?

If you compile for integer dates do they have the same range?

Also, that range is fine, unless you're tracking geological timeframes.  :)
В списке pgsql-general по дате отправления
От: Bruce Momjian
Дата:
От: Scott Marlowe
Дата:
Сообщение: Re: auto-vacuum questions
FAQ