I have a table with geometries, all with about 13 digits of accuracy. While trying to represent them with ST_AsText though, most vertices come out in decimal notation, but some come out in scientific notation. Problem is, I'm extracting these geometries in a python script and parsing them to arrays through regular expression, and the e- notation is screwing this up.
This does not happen frequently, but once is enough to halt the entire process (or more precisely, generate incorrect results for the remainder of the geometry). I have tried truncating the coordinate values to less digits, but it matters not, the same vertices get modified by some reason. ST_AsEWKT turns up the same problem, as expected.
Why is this happening? Any solutions I could use to either solve this problem or work around it?