How can I disable or remove scientific notation from a number in PostgreSQL

Viewed 35

I need to remove scientific notation (more specifically from a point, but just from a the x and y coordinate seems more feasible) or disable it when using st_centroid in postgres. Ex. Point(0.000055332622863 -2.109423746787797e-15)

Looking for a way to do this that would work for an entire column if values like this.

0 Answers
Related