Re: Decimal digits in timeofday() - Mailing list pgsql-bugs

Nicola Larosa <nico@tekNico.net> writes:
> There's a cute little bug somewhere.

Only that the default display precision for float8 is 15 digits.

regression=#  SELECT date_part('epoch', now());
    date_part
------------------
 1003952920.01861
(1 row)

regression=# select '1003952920.01861'::float8;
      float8
------------------
 1003952920.01861
(1 row)

regression=# select '1003952920.018612'::float8;
      float8
------------------
 1003952920.01861
(1 row)

regression=# select '1003952920.018612'::float8 - 1003952920.0;
      ?column?
--------------------
 0.0186120271682739
(1 row)

regression=#

            regards, tom lane