👀 Views: 31 💬 Answers: 1 📅 Created: 2025-06-10

django postgresql decimal orm Python

I can't seem to get I'm working through a tutorial and I've hit a wall trying to I tried several approaches but none seem to work....... I'm working with a precision scenario when saving and retrieving decimal values from a PostgreSQL database using Django 3.2. When I save a value like `Decimal('10.123456789')`, I expect it to be preserved with all its precision. However, after saving and retrieving, it appears truncated to `Decimal('10.12345678')`, losing some important digits. I've set my model field like this: ```python from django.db import models class Product(models.Model): price = models.DecimalField(max_digits=10, decimal_places=8) ``` In my database, the column type is set to `numeric(10, 8)`, which seems correct based on the model definition. Despite that, I'm seeing this truncation scenario. I've tried using `get_decimal_places()` to confirm the number of decimal places but it returns 8 as expected. Additionally, I’ve looked into PostgreSQL settings, and I found no explicit precision restrictions. I even attempted to save the value as a string before converting to Decimal, hoping it might help: ```python price = Decimal(str(10.123456789)) # Trying to save as string product = Product(price=price) product.save() ``` Unfortunately, the retrieve step still shows the same truncated value. Has anyone faced a similar question or have suggestions on how to ensure the precision is maintained throughout the process? Any help would be greatly appreciated! Thanks in advance! For context: I'm using Python on Windows. Am I missing something obvious? Has anyone dealt with something similar? Am I missing something obvious? This is part of a larger mobile app I'm building.