Re: Mapping Java BigDecimal

> I would like to disagree with the statement that PostgreSQL
> numeric is a real with rounding to the precision specified.


I concede my mis-statement.

> Hi All,
>
> We decide add support PostgreSQL database (now supporting only Oracle
> database) to our product.
>
> In Oracle we mapping Java BigDecimal to number(19, 2), in PostgreSQL
> to numeric(19, 2).
>
> If I store to "BigDecimal column" number without decimal, e.g. "3",
> than Oracle JDBC driver return "3", but PostgreSQL JDBC driver return
> "3.00".
>
> Is there some way (mapping, server setup, jdbc driver setup,...) how
> reach return number without trailing zeroes on decimal position?
>
> I'm using JDBC4 PostgreSQL Driver (v. 8.4-701) and PostgreSQL v.
> 8.1.18 (default for CentoOS 5.3).
> Thank you all


Oracle NUMBER(19,2), (precision,scale) is just the same as
NUMERIC(19,2), but if do

Oracle NUMBER(19,2) ----> PostgreSQL Numeric, no precision yields the
desired result
as Jakub has figured out and keeps whatever precision input.

danap.