What data type can i use to prevent rounding?

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

1 Like

Complete fluke that I had the same problem that morning!