Re: Mapping Java BigDecimal

Jakub Bednář wrote:
> 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".

does a java BigDecimal number have a fixed  2 digit fraction precision
like that?   If not, why not just define it as NUMERIC and let the
fractional part 'float' as assigned. ?