Mapping Java BigDecimal - Mailing list pgsql-general

From Jakub Bednář
Subject Mapping Java BigDecimal
Date
Msg-id 4B54199C.5020905@b2bcentrum.cz
Whole thread Raw
Responses Re: Mapping Java BigDecimal  (Lew <noone@lwsc.ehost-services.com>)
List pgsql-general
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,...) how reach return number
without trailing zeroes on decimal position?

I'm using PostgreSQL v. 8.1.18 (default for CentoOS 5.3).
Thank you all

----

Jakub Bednar

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: vacuum issues under load?
Next
From: Brian
Date:
Subject: does ispell have allaffixes set to on?