Python writes float to Postgresql but it is precision is lesser

Question

I am writting such float value from Python (6.481044303797468) converted to string via StringIO '6.481044303797468' into Postgresql column of type NUMERIC(13,8). I read it back into Python which is returned as Decimal('6.48104430').

Why the precision is smaller?

NUMERIC(13,8) means the precision of 8.

klin
– klin

2019-01-16 13:51:03 +00:00
Commented Jan 16, 2019 at 13:51 — klin
– klin, Commented Jan 16, 2019 at 13:51

S-Man · Accepted Answer · 2019-01-16 14:06:51Z

2

NUMERIC(13,8) means: 8 decimal digits. So you are getting exactly what you saved.

edited Jan 16, 2019 at 14:06

answered Jan 16, 2019 at 13:50

S-Man

24k9 gold badges51 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nav · Accepted Answer · 2019-01-16 13:52:22Z

0

You asekd to remember just 8 digits after decimal point in here NUMERIC(13,8) change type for what your precision is desired

answered Jan 16, 2019 at 13:52

Nav

8211 bronze badges

Collectives™ on Stack Overflow

Python writes float to Postgresql but it is precision is lesser

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related