Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PostgreSQL: real type is "6 decimal digits precision" #327

Open
Kexkey opened this issue Jan 2, 2024 · 1 comment
Open

PostgreSQL: real type is "6 decimal digits precision" #327

Kexkey opened this issue Jan 2, 2024 · 1 comment

Comments

@Kexkey
Copy link
Collaborator

Kexkey commented Jan 2, 2024

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
Copy link
Collaborator Author

Kexkey commented Feb 26, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Kexkey