"Randy Solomonson" <pgsqlbugs@solomonson.com> writes:
> When converting from Timestamp with Time zone to seconds since epoch, the
> last digit of the fraction of a second is missing.
The result of extract() is float8, so you can't really expect it to
have more than about 15 digits of precision.
regards, tom lane