Re: precision of numeric type

----- Original Message -----
From: "Barry Lind" <blind(at)xythos(dot)com>
To: "w.winter" <w(dot)winter(at)logitags(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Tuesday, October 29, 2002 5:53 PM
Subject: Re: [JDBC] precision of numeric type

> >
> > I store the Double value 1212121234.5634349876 with a
> > PreparedStatement.setDouble()
> >
>
> But the problem is that java Double isn't able to perform calculations
> exactly. If you want exact precision you should be using the BigDecimal
> datatype (and getBigDecimal/setBigDecimal). BigDecimal is the logical
> java data type that corresponds to the numeric type in postgres.
>

Hi Barry,

you are right, that was my error. I will use BigDecimal in this case.

thank you for the hint
Wolfgang