On 11/20/2011 02:06 PM, Tom Lane wrote:
Lee Hachadoorian writes:
And can I reliably retrieve the original integer by
casting to int (or bigint) if the number of digits in the original
integer is less than 15?
On IEEE-floating-point machines, I'd expect float8 to store integers
up to 2^52 (or m
On 11/20/11 1:29:37 PM, Lee Hachadoorian wrote:
I would like to store some in a single array some data that is
conceptually related, but some of the data is floating point, and some
of it is integer. Obviously the integer data *can* be stored as double
precision, but I need to know about potentia
Lee Hachadoorian writes:
> And can I reliably retrieve the original integer by
> casting to int (or bigint) if the number of digits in the original
> integer is less than 15?
On IEEE-floating-point machines, I'd expect float8 to store integers
up to 2^52 (or maybe it's 2^53) exactly. With othe
I would like to store some in a single array some data that is
conceptually related, but some of the data is floating point, and some
of it is integer. Obviously the integer data *can* be stored as double
precision, but I need to know about potential loss of precision. Double
precision has "a p
