Re: Rounding error on extract(epoch ..)

Moshe Jacobson <moshe@neadwerx.com> writes:
> It seems that extract(epoch ..) does not preserve the entire precision of
> the passed-in timestamp.

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

            regards, tom lane