Re: [BUGS] BUG #5470: EXTRACT(epoch from ...) missing last digit

2010-05-24 Thread Tom Lane
"Randy Solomonson" 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. reg

[BUGS] BUG #5470: EXTRACT(epoch from ...) missing last digit

2010-05-24 Thread Randy Solomonson
The following bug has been logged online: Bug reference: 5470 Logged by: Randy Solomonson Email address: pgsqlb...@solomonson.com PostgreSQL version: 8.4.2 Operating system: Red Hat 4.1.2-46 (64-bit) Description:EXTRACT(epoch from ...) missing last digit Details: Wh