Postgres Pro
Downloads
Home   >   mailing lists

Re: Rounding error on extract(epoch ..) - Mailing list pgsql-bugs

From Moshe Jacobson
Subject Re: Rounding error on extract(epoch ..)
Date
Msg-id CAJ4CxLmNhHoFATaThraBL8FzPBQUtPTqDFjz6BmrhStupMomAg@mail.gmail.com
Whole thread Raw
In response to Re: Rounding error on extract(epoch ..)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
On Jan 24, 2014 11:52 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

> The result is float8, so being good to about 16 digits is expected
> behavior.

I see. But how is it that the correct result is returned when I pass the
output of extract straight into to_timestamp?

pgsql-bugs by date:

Previous
From: kieran.mccusker@gmail.com
Date:
Subject: BUG #8956: fedora download does not contain pg_config
Next
From: John R Pierce
Date:
Subject: Re: BUG #8956: fedora download does not contain pg_config