Re: [GENERAL] Mapping Java BigDecimal

2010-01-23 Thread Lew 

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".


Is there some way (mapping, server setup,...) how reach return number 
without trailing zeroes on decimal position?


There's no difference between those two values in Java's BigDecimal.

Are you saying that the 'scale' of the returned values differs between the 
JDBC for Oracle and that for PG?


--
Lew

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Mapping Java BigDecimal

2010-01-18 Thread Jakub Bednář 

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general