Re: jdbc rounding value for numeric fields

Thank you Tom,

My problem could be fixed with BigDecimal...

--- On Mon, 5/25/09, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Subject: Re: [JDBC] jdbc rounding value for numeric fields
> To: "Ioana Danes" <ioanasoftware(at)yahoo(dot)ca>
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Received: Monday, May 25, 2009, 11:15 AM
> Ioana Danes <ioanasoftware(at)yahoo(dot)ca>
> writes:
> >           
> ps.setDouble(1,2.6999999999999997);
>
> Don't use setDouble.  float8 to numeric conversion
> only preserves
> DBL_DIG (ie, 15 on standard platforms) decimal digits,
> since that's
> the most that can be fully trusted in a float8 value.
>
>            
> regards, tom lane
>

__________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr!

http://www.flickr.com/gift/