Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Problem with java infinity mapping to postgres real column type
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: Johan Miller <johanmiller(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Problem with java infinity mapping to postgres real column type
- Date: Wed, 16 Jul 2008 23:52:19 -0400 (EDT)
- Message-id: <Pine.BSO.4.64.0807162351110.28897@leary.csoft.net> <text/plain>
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: overflowI would have expected that the float8 -> float4 conversion would just keep it as infinity.
Kris Jurka
- Follow-Ups:
- References:
- Problem with java infinity mapping to postgres real column type
- From: Johan Miller
- Re: Problem with java infinity mapping to postgres real column type
- From: Tom Lane
- Problem with java infinity mapping to postgres real column type
- Prev by Date: Re: Problem with java infinity mapping to postgres real column type
- Next by Date: Re: Problem with java infinity mapping to postgres real column type
- Previous by thread: Re: Problem with java infinity mapping to postgres real column type
- Next by thread: Re: Problem with java infinity mapping to postgres real column type
- Indexes: