Re: precision of numeric type

----- Original Message -----
From: "Barry Lind" <blind@xythos.com>
To: "w.winter" <w.winter@logitags.com>
Cc: <pgsql-jdbc@postgresql.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