"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
regression=# select 'infinity'::float4;
regression=# select '-infinity'::float4;
regards, tom lane
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2008-07-17 03:52:19|
|Subject: Re: Problem with java infinity mapping to postgres real column
|Previous:||From: Pushker Chaubey||Date: 2008-07-16 08:36:16|
|Subject: Re: Transaction handling through java|