On Wed, 16 Jul 2008, Tom Lane wrote:
> It sounds like "infinity" is getting translated to "some large number"
> rather than the correct "Infinity" or "-Infinity" symbol. The latter
> two should work on IEEE-compliant platforms, but you might want to check
> manually:
Actually the problem is:
jurka=# select 'infinity'::float8::float4;
ERROR: type "real" value out of range: overflow
I would have expected that the float8 -> float4 conversion would just keep
it as infinity.
Kris Jurka