In the image you can see the query and the results.
gas_native is a string. I need to convert it to a datatype that lets me do operations but everything I try results in the values being rounded. As you can see in the column after.
What can i use to prevent rounding?
I have tried float64, NUMERIC, BIGNUMERIC. nothing works.
how many decimal values are you keeping? Cause i believe that is more of a formatting issue
If not a formatting issue, can you run the same query against your DB and share with us what results you get?
What happens when you visualise the results in a table rather than staying in the query window?
I had a similar issue this morning where coordinates were being rounded down to 2 significant figures in the query view, but all was fine when visualised.
Changing the display fixed this.
Thanks I was not aware
Complete fluke that I had the same problem that morning!
