Re: Timestamp precision

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Timestamp precision
Дата
Msg-id 29590.1175196716@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Timestamp precision  ("John D. Burger" <john@mitre.org>)
Список pgsql-general
"John D. Burger" <john@mitre.org> writes:
> Hmm, except if the timestamp "anchor" is installation-specific, then
> binary exchange of timestamps is complicated.

Yeah, that would be a problem.

> What does libpq do now
> with timetamps, if the client requests data in binary form?  How does
> the client know whether it's getting floats or integers?

You have to look at the integer_datetimes parameter (which is available
to the client automatically in recent versions, though whether you can
get at it easily depends on your client library...)

            regards, tom lane

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

Предыдущее
От: Edoardo Panfili
Дата:
Сообщение: Re: Codifica database
Следующее
От: Joseph S
Дата:
Сообщение: Re: Slow sequential scans on one DB but not another; fragmentation?