Magnus Hagander <[EMAIL PROTECTED]> writes:
> Float is an approximate datatype. In this case, linux makes a fairly
> wild approximation (that it's the same as infinity) whereas windows
> says it just can't approximate it.
Note that the behavior isn't consistent across Unixen either ---
my HPUX box
Richard Wang wrote:
> I run the following sql statements in linux and get the results:
> postgres=# create table test_double(col1 float8);
> CREATE TABLE
> postgres=# insert into test_double values(1.7976931348623159E308);
> INSERT 0 1
> postgres=# select * from test_double;
>col1
> --
If you look into documentation, the behavior of float/double is platform depend.
If you want to same result on any platform, use numeric instead.
Zdenek
Richard Wang napsal(a):
I run the following sql statements in linux and get the results:
postgres=# create table test_double
I run the following sql statements in linux and get the results:
postgres=# create table test_double(col1 float8);
CREATE TABLE
postgres=# insert into test_double values(1.7976931348623159E308);
INSERT 0 1
postgres=# select * from test_double;
col1
--
Infinity
(1 row)
but in windows:
p
