"Randy Solomonson" <pgsqlb...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs