Thread: [DOCS] ST_AsLatLonText bug

[DOCS] ST_AsLatLonText bug

From
mmalorodova@usgs.gov
Date:
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

Re: [DOCS] ST_AsLatLonText bug

From
Mike Toews
Date:
On 18 January 2017 at 09:57,  <mmalorodova@usgs.gov> wrote:
> 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

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.