Re: Timestamp precision

"John D. Burger"  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