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

"Johan Miller" <johanmiller(at)gmail(dot)com> writes:
> I have found that when trying to insert a Java Float.POSITIVE_INFINITY or
> its negative counterpart into a database column with data type real using a
> jdbc driver 8.1-406 or 8.2-504 postgres will throw an overflow error.
> Since both Java and Postgres real data type support infinity then this seems
> very strange.

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:

regression=# select 'infinity'::float4;
float4
----------
Infinity
(1 row)

regression=# select '-infinity'::float4;
float4
-----------
-Infinity
(1 row)

regards, tom lane