[DOCS] instr function with negative parameter

2017-01-17 Thread mmalorodova
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/static/plpgsql-porting.html Description: instr function with negative parameter does not return the same result as in Oracle Ex: select instr('01101001001','1',-1) from dual -- Sent

[DOCS] ST_AsLatLonText bug

2017-01-17 Thread mmalorodova
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

Re: [DOCS] ST_AsLatLonText bug

2017-01-17 Thread Mike Toews
On 18 January 2017 at 09:57, 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