Skip to content

Instantly share code, notes, and snippets.

@jczaplew
Created January 8, 2015 14:19
Show Gist options
  • Save jczaplew/af97dc26539759425ce3 to your computer and use it in GitHub Desktop.
Save jczaplew/af97dc26539759425ce3 to your computer and use it in GitHub Desktop.
PostGIS doesn't add extra decimal places
WITH point AS (SELECT ST_GeomFromText('POINT(-89.1 43.2)') AS geom)
SELECT ST_AsText(geom) from point
-- Outputs "POINT(-89.1 43.2)"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment