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.