Skip site navigation (1) Skip section navigation (2)

Re: Bug : FAST_NUMBER_FAILED when getting NaN on BigDecimal

From: Florent Guillaume <fg(at)nuxeo(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: DocSea - Patrice Delorme <pdelorme(at)docsea(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bug : FAST_NUMBER_FAILED when getting NaN on BigDecimal
Date: 2012-09-12 13:35:39
Message-ID: CAF-4BpPTHo3zXV_hk8Yy_3MHrz2c5KUeeohyzjjVzUHuFtOF3A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Tue, Sep 11, 2012 at 4:10 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> DocSea - Patrice Delorme <pdelorme(at)docsea(dot)com> wrote:
>
>> It is impossible to fetch data when numeric value in database is
>> NaN
>> It throws FAST_NUMBER_FAILED
>> (postgresql-jdbc-9.1-902:AbstractJdbc2ResultSet:2176) because my
>> value is not numeric (NaN).
>> This is incorect behaviour since 'NaN' is a legal value in
>> postgres for numeric type.
>
> How do you expect what you read to be represented in Java?

java.lang.Double.NaN I guess.


-- 
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87


In response to

Responses

pgsql-jdbc by date

Next:From: David JohnstonDate: 2012-09-12 14:15:24
Subject: Re: Bug : FAST_NUMBER_FAILED when getting NaN on BigDecimal
Previous:From: Dave CramerDate: 2012-09-12 11:33:33
Subject: Re: send/receive buffer size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group