On 2012-05-29, David Salisbury <salisb...@globe.gov> wrote: > > > 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?
yeah, the microseconds appear as fractions of seconds, so in the conversion to integer epoch they get rounded off. > > Thanks, > > -ds > -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
