Re: Timestamp precision - Mailing list pgsql-general

From Tom Lane
Subject Re: Timestamp precision
Date
Msg-id 29590.1175196716@sss.pgh.pa.us
Whole thread Raw
In response to Re: Timestamp precision  ("John D. Burger" <john@mitre.org>)
List 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 by date:

Previous
From: Edoardo Panfili
Date:
Subject: Re: Codifica database
Next
From: Joseph S
Date:
Subject: Re: Slow sequential scans on one DB but not another; fragmentation?