<div>
Thanks, I went with postgres's Number field, that way you can still use the field as a number in query's
</div>


Thanks, I went with postgres's Number field, that way you can still use the field as a number in query's

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm currently developing a JAVA application that needs to calculate financial data, so I'm using BigDecimals to avoid inaccurate calculations.<br />
<br />
How should I store these Bigdecimals in a postgresql db? which datatype should I use?<br />
<br />
Regards Kristof
</div>
</div>


Hi,

I'm currently developing a JAVA application that needs to calculate financial data, so I'm using BigDecimals to avoid inaccurate calculations.

How should I store these Bigdecimals in a postgresql db? which datatype should I use?

Regards Kristof

Bigdecimal, postrgesql

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.