ST_AsLatLonText bug
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.0/static/plpgsql-porting.html
Description:
select
(ST_AsLatLonText('POINT ('||(-76.6)||' '||(35.1)||')', 'DD°MM''SS.SSS"C'))
dms
returns unexpected 60 seconds
35° 6'0.000"N 76°35'60.000"W
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
On 18 January 2017 at 09:57, <mmalorodova@usgs.gov> wrote:
select
(ST_AsLatLonText('POINT ('||(-76.6)||' '||(35.1)||')', 'DD°MM''SS.SSS&C'))
dmsreturns unexpected 60 seconds
35° 6'0.000&N 76°35'60.000&W
This is not a PostgreSQL bug. PostGIS bugs go to https://trac.osgeo.org/postgis
See https://trac.osgeo.org/postgis/ticket/3688 for this issue.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs