On Wed, 10 Mar 2004, Tom Lane wrote:
> > nconway=# select 'Infinity'::float8;
> > ERROR: type "double precision" value out of range: overflow
>
> This works in 7.4 and older releases. Sounds to me like you broke it.
It does not work on 7.3 and 7.4 when I try.
Looking at the currect cvs code it's not just parsing 'Infinity' as a
value, there is also an overflow check after float operations that will
exclude Infinity and Nan.
By the way, this thing was discussed on irc and I just sent a mail on
-hackers about it, not knowing about this thread here.
There are too many lists :-)
--
/Dennis Björklund