Magnus Hagander <magnus(at)hagander(dot)net> 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 acts like Windows here. Basically Postgres just tries
to reflect the platform's floating-point support.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Marc G. Fournier||Date: 2008-04-02 20:53:01|
|Subject: Re: Several tags around PostgreSQL 7.1 broken|
|Previous:||From: Mark Mielke||Date: 2008-04-02 20:34:09|
|Subject: Re: [GENERAL] SHA1 on postgres 8.3|