cyphernode icon indicating copy to clipboard operation
cyphernode copied to clipboard

PostgreSQL: real type is "6 decimal digits precision"

Open Kexkey opened this issue 2 years ago • 2 comments

https://www.postgresql.org/docs/current/datatype-numeric.html

Currently, watching_tx.amount, recipient.amount as well as tx.fee columns are of type real which causes precision loss when the value is > 1.

We need to change those types to double.

Kexkey avatar Jan 02 '24 18:01 Kexkey

Let's move from floats to bigints for persistance and deal with decimal points in responses only...

Kexkey avatar Feb 26 '24 13:02 Kexkey