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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings