Re: [JDBC] Problem with java infinity mapping to postgres real column type

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

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc