Re: timestamps, formatting, and internals - Mailing list pgsql-general

From David Salisbury
Subject Re: timestamps, formatting, and internals
Date
Msg-id 4FC55B9A.7080409@globe.gov
Whole thread Raw
In response to Re: timestamps, formatting, and internals  (Jasen Betts <jasen@xnet.co.nz>)
Responses Re: timestamps, formatting, and internals
List pgsql-general

On 5/27/12 12:25 AM, Jasen Betts wrote:
> The query: "show integer_datetimes;" should return 'on' which means
> timestamps are microsecond precision if it returns 'off' your database
> was built with floating point timstamps and equality tests will be
> unreliable,

I find that rather interesting.  I was told that I was losing microseconds
when I extracted an epoch from the difference between two timestamps and casted
that value to an integer.  So if I have integer timestamps ( your case above )
I get microseconds, but integer epochs is without microseconds?

Thanks,

-ds

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Updateable Views or Synonyms.
Next
From: David Kerr
Date:
Subject: select current_setting('transaction_isolation')