SELECT query to database returns wrong decimal values. about asyncpg

[thomas-mckay]

Probably a precision error when converting to a Python float: https://magicstack.github.io/asyncpg/current/usage.html#id3

Try casting to decimal in your query, see if it changes.

On a side-note, though related if I understand your table correctly, I'd suggest using a fixed-length array of integers for version numbers. Even if you're absolutely sure you'll never have values like 3.14.2, a version number is not a float (or a decimal). And comparison becomes natural with an array of ints:

• [3, 14] > [3, 5]
• 3.14 < 3.5

[JavaProgswing]

Oh yep having a list of integers is definitely better. I'll do that.

I'll try casting and see if it works. Cuz was working normally in a other python library.