Is there a decimal or fixed-point data type in Neo4j? I'm thinking of something like DECIMAL
or NUMBER
in various SQL DBs or Java's BigDecimal
.
If not, what are the best practices if I need to work with decimal data with Neo4j (saving, calculating, reading)?
My use case is:
I am working with real-world measurements (length, weight etc.) with a given precision. E.g. I have data in meters with a precision of millimeters, i.e. 3 decimal numbers. I'd like to
a) store the numbers with this precision so that I can do equality checks using this precision (i.e. measurement with same millimeter value is equal).
b) read out the numbers with this precision only because any higher apparent precision is meaningless and confusing
c) calculate intermediate (in-memory) values with some higher precision so that intermediate calculations don't introduce additional rounding/cancellation errors
Currency could be another use case, which we don't have, but how do people model that?