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

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"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