Re: Problem with java infinity mapping to postgres real column type - Mailing list pgsql-jdbc

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